Thread: Blanks in VLookUP
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default Blanks in VLookUP
Try

=IF(ISNA(VLOOKUP(P16,P28:R33,3)),0,VLOOKUP(P16,P28 :R33,3))

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Phil Hageman" wrote in message ...
What code could be added to this formula, such that if P16
is blank, the cell holding this formula would also be
blank? What I get now is an error (#N/A) when P16 is
blank.

=VLOOKUP(P16,P28:R33,3)


Reply With QuoteReply With Quote