how to get rid of #N/A

M

Mahesh

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
 
M

Mike H

Maybe:-

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

Mike
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to get rid of #n/a 1
VLOOKUP #N/A Error 7
vlookup errors #n/a 10
lookup formula not picking up correct data 2
Summing #N/A occurrences 5
getting #N/A when vlookup is a negative number 3
#N/A in lookup function 3
getting rid of "#N/A" in columns 9

Top