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
"jspizman" wrote in
message ...
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
--
jspizman
------------------------------------------------------------------------
jspizman's Profile:
http://www.excelforum.com/member.php...o&userid=30694
View this thread: http://www.excelforum.com/showthread...hreadid=503584