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