VLOOKUP question
 

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

VLOOKUP question
 

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

VLOOKUP question
 

Hi

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


Arvi Laanemets


"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

VLOOKUP question
 

The formulas worked out very well. Thank you for the help.


--
jspizman
------------------------------------------------------------------------
jspizman's Profile: http://www.excelforum.com/member.php...o&userid=30694
View this thread: http://www.excelforum.com/showthread...hreadid=503584