VLOOKUP question

[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

[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

"jspizman" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Arvi Laanemets]

Hi

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


Arvi Laanemets


"jspizman" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[jspizman]

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