If/Or/VLookup Formula

The VLookup portion of this formula works. I tacked on the OR portion and
can’t get things to operate. If cell T40 is zero, or has a (legitimate)
#DIV/0! Error, I want cell T40 blank, otherwise execute the VLookup.

=(IF(OR(T40=0,ISERROR,""),VLOOKUP(T40,$AT$8:$AU$12,2)))

Maybe...

=(IF(OR(T40=0,ISERROR(t40)),"",VLOOKUP(T40,$AT$8:$AU$12,2)))

Phil Hageman wrote:
>
> The VLookup portion of this formula works. I tacked on the OR portion and
> can’t get things to operate. If cell T40 is zero, or has a (legitimate)
> #DIV/0! Error, I want cell T40 blank, otherwise execute the VLookup.
>
> =(IF(OR(T40=0,ISERROR,""),VLOOKUP(T40,$AT$8:$AU$12,2)))

--

Dave Peterson

=IF(OR(ISERROR(T40),T40=0,T40=""),"",VLOOKUP(T40,$AT$8:$AU$12,2))

"Phil Hageman" wrote:

> The VLookup portion of this formula works. I tacked on the OR portion and
> can’t get things to operate. If cell T40 is zero, or has a (legitimate)
> #DIV/0! Error, I want cell T40 blank, otherwise execute the VLookup.
>
> =(IF(OR(T40=0,ISERROR,""),VLOOKUP(T40,$AT$8:$AU$12,2)))
>

Kassie and Dave,

Thanks for your answer - both formulas worked. Appreciate the help.

Phil

"Kassie" wrote:

> =IF(OR(ISERROR(T40),T40=0,T40=""),"",VLOOKUP(T40,$AT$8:$AU$12,2))
>
> "Phil Hageman" wrote:
>
> > The VLookup portion of this formula works. I tacked on the OR portion and
> > can’t get things to operate. If cell T40 is zero, or has a (legitimate)
> > #DIV/0! Error, I want cell T40 blank, otherwise execute the VLookup.
> >
> > =(IF(OR(T40=0,ISERROR,""),VLOOKUP(T40,$AT$8:$AU$12,2)))
> >