How do I create an "IF" formula that returns a false arugment if .

S

Shaun

How do I create an "IF" formula that returns a false arugment if the logical
test results in error? I'm trying to use a "lookup" function for multiple
areas, and if the first lookup results in no match, I want it to go to the
second range and so forth. If there is another formula than a "IF" formula
to accomplish this, then let me know that also. Thanks.
 
J

JulieD

Hi Shaun

if the lookup results in a #NA error you can use
=IF(ISNA(your_first_formula),your_second_formula,your_first_formula)

Hope this helps
Cheers
JulieD
 
B

BenjieLop

Shaun said:
How do I create an "IF" formula that returns a false arugment if th
logical
test results in error? I'm trying to use a "lookup" function fo
multiple
areas, and if the first lookup results in no match, I want it to go t
the
second range and so forth. If there is another formula than a "IF
formula
to accomplish this, then let me know that also. Thanks.
Click to expand...

Will this help?

=if(iserror(your_formula,"",your_formula
 
B

BenjieLop

Thank you, Dave ...

One can never realize how a parenthesis can really make or break
formula ...
 
Top