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
|