Associate a name with an amount

**BradP** · 08-08-2013, 10:59 AM

Good Morning:

My spreadsheet contains 242 rows and 15 columns are data; each row contains a piece of material. In column "A" the name of the materials are listed and column "D" estimated profit dollars are recorded.

I am using the "Large" and "Small" function to list the Top 10 (Largest and Smallest) estimated profit dollars from (Column D). I am manually typing in the names of the materials (Column) resulting for the function.

I am unable to figure out a function or equation to have the material's name automatically appear. Is there a function/equation/way that will record the materials name based on the amount?

Thanks

**Fotis1991** · 08-08-2013, 11:12 AM

Perhaps if you don't exactly same numbers in your top list, an INDEX & MATCH will work..

Assuming that you have the top 10 numbers in range H2:H11, then in I2 and copy down use this..

=INDEX($A$2:$A$1000,MATCH($H1,$D$2:$D$1000,0))

**BradP** · 08-08-2013, 12:17 PM

Thank you for your help; your solution worked.

Have a great day.

**Fotis1991** · 08-08-2013, 12:27 PM

It's evening here!

You are welcome and thanks for the feed back.

As that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thank you.

Also, as an old member-but with few posts- of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.