Thread: How do I eliminate "false" from showing in a cell?
View Single Post
  #13   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK
 
Posts: n/a
Default How do I eliminate "false" from showing in a cell?
Sorry, there is a missing bracket from my formula - it should be:

=IF(ISNA(VLOOKUP(B9,Q12:R41,2,0)),"",VLOOKUP(B9,Q1 2:R41,2,0))

This should correct it now (thanks to Bob's earlier response!)

Pete

Reply With QuoteReply With Quote