View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein \(MVP - VB\)[_849_] Rick Rothstein \(MVP - VB\)[_849_] is offline
external usenet poster
 
Posts: 1
Default how do i replace #n/a in a vlookup?

I was missing a parenthesis when transferring your formula
to my spreadsheet.


Copy/Paste'ing into the Formula Bar (followed by removing any line feeds
produced by your newsreader) usually avoids that kind of problem.

Rick