Thread: vlookup false gives "#N/A" - can it say something else?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Bob is offline
external usenet poster
  
Posts: 972
Default vlookup false gives "#N/A" - can it say something else?
VLOOKUP(D3,F7:G114,2,FALSE)
The false part produces "#N/A" if there is not an exact match.
Can I substitute some other text for the "#N/A"? Like "NO MATCH"?
Thanks much! -Bob
Reply With QuoteReply With Quote