Don't use LOOKUP(), use VLOOKUP() (or HLOOKUP()) instead. There you can
specify wheter or not the table is sorted, wheter an exact match should be
returned, etc

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Tom" wrote in message
...
I see that when using the lookup function, if the lookup value entered does
not match anything in the lookup vector, the result vector returns as the
next lowest value. Is there any way to change that so that if there is no
match you get a #VALUE! result instead, or something other than the next
lowest value?