Sorry...should've explained. The FALSE tells Excel NOT to find the nearest
value, but to find the EXACT value. See:
http://www.officearticles.com/excel/...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com
"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