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.

=IF(ISNA(“<yourformula>”),””,”<yourformula>”)

for example:

=IF(ISNA(VLOOKUP(A1,B1:B26,1,FALSE)),””,VLOOKUP(A1,B1:B26,1,FALSE))

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