Thread: how to replace #N/A with my Vlookup
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] charlottejane123.cn@gmail.com is offline
external usenet poster
  
Posts: 1
Default how to replace #N/A with my Vlookup
Cant seem to work this out, can you please show me how to replace the #N/A with a blank if the value searched is not found

=VLOOKUP(D2,Q2:W47,6, False)

many thanks
Reply With QuoteReply With Quote