#n/a's

  • Thread starter Thread starter Bill Wilson
  • Start date Start date
B

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.
 
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
 
Back
Top