You can use the Excel formula ISNA to remove excel producing ‘#N/A’ results in cells.

This is especially useful when using VLOOKUP functions which seach for values in one column and return values in other columns.

How to use it:

Using ISNA is conjunction with IF, you can create a formula that will replace #N/A when it appears.


for example:


This is my site Written by Tim Jolley on August 26, 2010 – 4:13 pm