You will have the option to require an exact match if you use the VLOOKUP
function instead of LOOKUP.

On Tue, 27 Sep 2005 14:19:05 -0700, "Radha"
wrote:

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