Thread: How can I make the box remain empty instead of N/A#
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR
 
Posts: n/a
Default How can I make the box remain empty instead of N/A#
=IF(ISNA(VLOOKUP(E5,Sheet2!A:D,4,FALSE)),"",VLOOKU P(E5,Sheet2!A:D,4,FALSE))


Vaya con Dios,
Chuck, CABGx3


"VegasBurger" wrote:

currently I am using this formula =VLOOKUP(E5,Sheet2!A:D,4,FALSE) in one of
my cells. Now when E5 is empty this cell displays N/A#, how can I change it
to either show a symbol such as - or remain empty?

Thank you
Reply With QuoteReply With Quote