how to get rid of #N/A

Mahesh · Nov 28, 2007

when ever we are using some lookup function, in case if there is no
corresponding value, we get #N/A

so let me know how to get rid of it

Mike H · Nov 28, 2007

Maybe:-

=IF(ISNA(VLOOKUP(A1,B1:C3,2,FALSE)),"Not Found",VLOOKUP(A1,B1:C3,2,FALSE))

Mike

Gord Dibben · Nov 28, 2007

Example formula to trap for #N/A

=IF(ISNA(VLOOKUP(G2,$C$1:$F$31,2,FALSE)),"",VLOOKUP(G2,$C$1:$F$31,2,FALSE))

Gord Dibben MS Excel MVP