VLOOKUP and #N/A
 

How do I do a VLOOKUP and return nothing instead of #N/A?
For instance, if I have D1= "=VLOOKUP(C1,$A$1:$B$3,2,FALSE)"
Instead of #N/A I would rather get nothing.

A B C D
1 5 Red 3 #N/A
2 10 Blue 5 Red
3 15 Green 15 Green
4

VLOOKUP and #N/A
 

One way:

=IF(COUNTIF(A$1:A$3,C1),VLOOKUP(C1,A$1:B$3,2,0),"" )


--
Biff
Microsoft Excel MVP


"Rj" wrote in message
...
How do I do a VLOOKUP and return nothing instead of #N/A?
For instance, if I have D1= "=VLOOKUP(C1,$A$1:$B$3,2,FALSE)"
Instead of #N/A I would rather get nothing.

A B C D
1 5 Red 3 #N/A
2 10 Blue 5 Red
3 15 Green 15 Green
4

VLOOKUP and #N/A
 

try this to ignore #NA and return a blank instead

=IF(ISNA(VLOOKUP(C1,$A$1:$B$3,2,0)),"",VLOOKUP(C1, $A$1:$B$3,2,0))
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked


Thank You

cheers, francis










"Rj" wrote:

How do I do a VLOOKUP and return nothing instead of #N/A?
For instance, if I have D1= "=VLOOKUP(C1,$A$1:$B$3,2,FALSE)"
Instead of #N/A I would rather get nothing.

A B C D
1 5 Red 3 #N/A
2 10 Blue 5 Red
3 15 Green 15 Green
4