#n/a's

[Bill Wilson]

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.

 

[John Wilson]

Bill,

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

e.g.
=IF(ISNA(yourlookup),"",yourlookup)
as an example in a formula:
=IF(ISNA(VLOOKUP(D1,A1:B4,2,FALSE)),"",VLOOKUP(D1,A1:B4,2,FALSE))

John