Using ISNA with OR

H

HBF

I need to make a formula that looks like the following:

=IF(ISNA(VLOOKUP...)
OR(VLOOKUP...=0)"",
VLOOKUP...


In human terms, if the Vlookup returns N/A or 0, show nothing (""),
otherwise show me the vlookup.

Any way to combine the ISNA with an OR statement?
 
P

Peo Sjoblom

I don't think that will work since it is an error, using the OR function
will return an error if no value is found


Peo
 
E

Elkar

Ah yes, you're right. I see how to fix it, but your solution would be far
more efficient. Thanks for the catch.
 
Top