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?
 
Ad

Advertisements

G

Guest

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

HTH,
Elkar
 
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
 
Ad

Advertisements

G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ISNA 4
ISNA help 1
ISNA and VLOOKUP 3
isna function 1
ISNA Function 4
IsNA(match 1
ISNA question 2
IF, ISNA & VLOOKUP 5

Top