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