Using ISNA with OR

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

[Peo Sjoblom]

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


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"HBF" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>

[Elkar]

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

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

[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


"Elkar" <[email protected]> wrote in message
news:[email protected]...
> =IF(OR(ISNA(VLOOKUP(...)),VLOOKUP(...)=0),"",VLOOKUP(...))
>
> 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
>>
>>

[Elkar]

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" <[email protected]> wrote in message
> news:[email protected]...
> > =IF(OR(ISNA(VLOOKUP(...)),VLOOKUP(...)=0),"",VLOOKUP(...))
> >
> > 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
> >>
> >>
>
>
>