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

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" <jspizman.21z0um_1137823801.3637@excelforum-nospam.com> wrote in
message news:jspizman.21z0um_1137823801.3637@excelforum-nospam.com...
>
> 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
>

Hi

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


Arvi Laanemets


"jspizman" <jspizman.21z0um_1137823801.3637@excelforum-nospam.com> wrote in
message news:jspizman.21z0um_1137823801.3637@excelforum-nospam.com...
>
> 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
>

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