Hi,

Use 0 as the last argument of the VLOOKUP() function - If you use a 0, then
you do not need to ensure that the first column be in ascending order.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Steve" wrote in message
...
Table (leftmost) must be in ascending order. Then is it correct that you
cannot use the same table to look for a different value in a different
column
?
Also, if it is not in ascending order, is it true that some of the values
may still be correct, but some are incorrect.

Thanks,

Steve