Use Vlookup() with 0 or False ( for exact match) as the fourth argument.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Radha" wrote in message
...
Hi,

If LOOKUP can't find the value I am looking for, it is giving the result
from the next smallest value.

But, if the LoopUp can not find matching, I just want either False or
N/A.
How do I get this?

Please Help,
Radha