View Single Post
  #1   Report Post  
Old February 15th 16, 08:13 PM posted to microsoft.public.excel.worksheet.functions
[email protected] charlottejane123.cn@gmail.com is offline
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2016
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