I tried the index function and I get the #N/A responce. Is there anyway I
can post the spreadsheet?
--
Duncan


"T. Valko" wrote:

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))

--
Biff
Microsoft Excel MVP


"Parks" wrote in message
...
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..
--
Duncan