View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jimar
 
Posts: n/a
Default Remove #N/A in vlookup result

I am using vlookup to return data for a particular reference number. If the
reference number is not available I would like to replace the #N/A returns
with the wording "No Response". Is this possible?
Thanks