Excel – using ISNA formula for removing #N/A in results
August 26th, 2010
No comments
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))