VLOOKUP question

J

jspizman

I am doing some work with the VLOOKUP function. If there is no match, I
currently receive #N/A. Is there any way that this can just return a
blank cell?

Thanks for the help,
Josh
 
B

Biff

Hi!

Try one of these:

=IF(ISNA(MATCH(A1,C1:C10,0)),"",VLOOKUP(A1,C1:D10,2,0))

=IF(COUNTIF(C1:C10,A1),VLOOKUP(A1,C1:D10,2,0),"")

Biff
 
A

Arvi Laanemets

Hi

=IF(ISNA(VLOOKUP(...)),"",VLOOKUP(...))
=IF(ISERROR(VLOOKUP(...)),"",VLOOKUP(...))


Arvi Laanemets
 
Top