Using LookUP
 

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

Radha, add a 4th argument FALSE to your formula, i.e.
=vlookup(a1,myrange,3,false)
************
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

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

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

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