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

[Guest]

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.

 

[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

 

[BenjieLop]

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.

Will this help?

=if(iserror(your_formula,"",your_formula

 

[Dave Peterson]

Darn parentheses!

=if(iserror(your_formula),"",your_formula)

 

[BenjieLop]

Thank you, Dave ...

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