Thread: Vlookup
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
HS[_2_] HS[_2_] is offline
external usenet poster
  
Posts: 17
Default Vlookup
Is it possible to do a vlookup and when the corresponding cell is empty that
it display nothing rather than a 0?

=VLOOKUP(B3,Data!A1:L1602,12,FALSE)

thank you!


Reply With QuoteReply With Quote