MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Find value in 1 col, move to adjacent


Posted by Victoria Gallop on April 05, 2001 10:14 AM

MS Excel-How do I look up the MAX value in one column, eg Height, then display the value in the same row, 4 columns to the left ie. Name?


Posted by Aladin Akyurek on April 05, 2001 10:26 AM

I'll just assume that you have names in say A1:A10 and hights in B1:B10. If so, you can use:

=INDEX(A1:A10,MATCH(MAX(B1:B10),B1:B10,0),1)

This will give you just the first name associated with the max-height.

If this is way off the mark, give us a bit more info how your data look like.

Aladin