Thread: Still looking to be rid of the #N/A on look up table
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
smiley61799 smiley61799 is offline
external usenet poster
  
Posts: 17
Default Still looking to be rid of the #N/A on look up table
I am not good at this at all, novice at best. This is my current formula,
are you able to tell me how to alter my formula to yield a - or 0? I
appreciate your help

=VLOOKUP(F12:F45,Sheet3!G4:H51,2,FALSE)

Reply With QuoteReply With Quote