Using vlookup in a table that is not in ascending order

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table with the 1st column in ascending order but the column I wish
to find the maximum value in is not in ascending order. When I use vlookup
it just returns the last number in the first column not the number that
corresponds to the max number. If I could attach the spreadsheet to be more
specific I would. Thanks in advance..
 
Do you want to return the value from the left column that corresponds to the
MAX value in the right column?

=INDEX(A1:A10,MATCH(MAX(B1:B10),B1:B10,0))
 
Yes
--
Duncan


T. Valko said:
Do you want to return the value from the left column that corresponds to the
MAX value in the right column?

=INDEX(A1:A10,MATCH(MAX(B1:B10),B1:B10,0))
Click to expand...
 
I tried the index function and I get the #N/A responce. Is there anyway I
can post the spreadsheet?
 
I just tested Biff's and it worked just fine looking for the max value in
col B and returning what is in col A.
You may send your workbook to me at the address BELOW.
 
With Biff's formula, all that was needed was to absolute the first column
and copy left to right
=INDEX($B$3:$B$93,MATCH(MAX(F3:F93),F3:F93,0))
=INDEX($B$3:$B$93,MATCH(MAX(G3:G93),G3:G93,0))
 
Back
Top