Post by Bill Wilso » Sat, 23 Aug 2003 22:47:55

How can I easily get rid of returned cell values of #N/A
without hitting the delete button manually on each cell
when using an VLOOKUP in a spreadsheet.


Post by John Wilso » Sat, 23 Aug 2003 23:09:33


The best thing to do is reconstruct your VLookups so that you'll never
get the #N/A.

as an example in a formula: