Thread: Vlookup
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fletch
 
Posts: n/a
Default Vlookup

My vlookup formual returns #N/A when there is not a match in my lookup table.
When there isn't a match, I would like the formula to return a balnk cell
rather than #N/A so that users don't think there are problems with the
formula. Any ideas?

Thanks