Thread: If/Or/VLookup Formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Phil Hageman[_4_] Phil Hageman[_4_] is offline
external usenet poster
  
Posts: 81
Default 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)))

Reply With QuoteReply With Quote