Ask Experts Questions for FREE Help !
Ask
    varadhu's Avatar
    varadhu Posts: 14, Reputation: 1
    New Member
     
    #1

    Nov 24, 2012, 01:40 PM
    Match function in Excel spread sheet
    Hi Guys,

    I have a set of data in excel spread sheet attached herewith.

    With a fixed allotment of money(budget), a consumer has to identify the best price offered by the supplier. The table attempts to identify the best price offered by the supplier on different products, viz. fridge, washing money etc.

    Utilizing the "match function" available in excel sheet the best price of the supplier closest to the budget price was identified. But the output was in numeric value which spots out the position only. But I want the name of the supplier available in the column heading to be shown as output instead of the position.

    Sample sheet showing the table and desired result is enclosed for reference
    With regards,

    varadhu
    Attached Files
  1. File Type: zip Excel sheet- match function.zip (10.9 KB, 22 views)
  2. JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
     
    #2

    Nov 25, 2012, 06:04 PM
    In C2, then copied down:

    =INDEX($D$1:$G$1, MATCH($B2, $D2:$G2, 1))
    varadhu's Avatar
    varadhu Posts: 14, Reputation: 1
    New Member
     
    #3

    Nov 26, 2012, 07:15 AM
    Wonderful!!

    It really worked.

    Thank you!
    Varadhu
    varadhu's Avatar
    varadhu Posts: 14, Reputation: 1
    New Member
     
    #4

    Nov 26, 2012, 07:20 AM
    Quote Originally Posted by JBeaucaire View Post
    In C2, then copied down:

    =INDEX($D$1:$G$1, MATCH($B2, $D2:$G2, 1))
    I have seen your posts and also your site.

    You are really wonderful. Actually after seeing your posts, I wanted to post the query direct to you. But wondered whether the forum rules as well as you would appreciate the same.

    As I expected, it is you, who had replied.

    Hats off and Thank You once again.

    Varadhu
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
     
    #5

    Dec 1, 2012, 06:55 PM
    Glad you like the site, lots to peruse and use, hope you do.

    Best to post your questions in the public forum for the benefit of all.

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

How to connect one excel sheet to other excel sheet [ 28 Answers ]

How to connect one excel sheet to other excel sheet.

How to link multiple excel sheets to one main source excel sheet [ 7 Answers ]

I have a master price list and multiple ( individule ) sheets for customers.. I would like to , when input data in the price list to link and update to all other sheets... ( I do not want to have a source sheet with tabs) Thanks

Modulation of data in excel spread sheets [ 0 Answers ]

Dear members, I have attached an excel sheet named “Ask me model table” for reference: 1) In the attached table, I have presented the trade data of 10 specific shares for a day, as on 19.11.2012. 2) The table has four sheets. 3) In sheet no.1 named basic data, based on the HIGH, LOW values of...

Link spread sheets sheet 1 to sheet 2 , 2 to sheet 3 [ 4 Answers ]

I have attach what I have done on the site. What I need to do is link all of the data from sheet one to sheet 2. All I have found so far is how to link one cell to the other cell. In sheet 1 I have af 3 to af 699 . I need to bring all that data to sheet 2 to (d3 to d24) Sheet 2 will link into...

Oracle Vs spread sheet [ 2 Answers ]

What is difference between oracle and spread sheet?


View more questions Search