Using ISNA with OR
 

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?


--
HBF
------------------------------------------------------------------------
HBF's Profile: http://www.excelforum.com/member.php...o&userid=34019
View this thread: http://www.excelforum.com/showthread...hreadid=537813

Using ISNA with OR
 

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


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"HBF" wrote in message
...

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?


--
HBF
------------------------------------------------------------------------
HBF's Profile:
http://www.excelforum.com/member.php...o&userid=34019
View this thread: http://www.excelforum.com/showthread...hreadid=537813

Using ISNA with OR
 

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

HTH,
Elkar


"HBF" wrote:


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?


--
HBF
------------------------------------------------------------------------
HBF's Profile: http://www.excelforum.com/member.php...o&userid=34019
View this thread: http://www.excelforum.com/showthread...hreadid=537813

Using ISNA with OR
 

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


"Elkar" wrote in message
...
=IF(OR(ISNA(VLOOKUP(...)),VLOOKUP(...)=0),"",VLOOK UP(...))

HTH,
Elkar


"HBF" wrote:


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?


--
HBF
------------------------------------------------------------------------
HBF's Profile:
http://www.excelforum.com/member.php...o&userid=34019
View this thread:
http://www.excelforum.com/showthread...hreadid=537813

Using ISNA with OR
 

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

"Peo Sjoblom" wrote:

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


"Elkar" wrote in message
...
=IF(OR(ISNA(VLOOKUP(...)),VLOOKUP(...)=0),"",VLOOK UP(...))

HTH,
Elkar


"HBF" wrote:


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?


--
HBF
------------------------------------------------------------------------
HBF's Profile:
http://www.excelforum.com/member.php...o&userid=34019
View this thread:
http://www.excelforum.com/showthread...hreadid=537813