Hi,

Check your "number" column, it might be formatted as text!

Regards!
Jean-Guy

"Parks" wrote:

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