If/Or/VLookup Formula
 

The VLookup portion of this formula works. I tacked on the OR portion and
cant 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)))

If/Or/VLookup Formula
 

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
cant 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/VLookup Formula
 

=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
cant 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)))

If/Or/VLookup Formula
 

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