Vlookup that does not return #N/A

=IF(ISNUMBER(MATCH(A1,B1:B100,0)),VLOOKUP(A1,B1:C100,2,0),"")


Regards,

Peo Sjoblom

"carl" wrote:

> Is there a way to modify the vlookup formula so that it return a blank versus
> #N/A.
>
> Thank you in advance.

try =if(iserror(vlookup),"",Vlookup)


"carl" wrote:

> Is there a way to modify the vlookup formula so that it return a blank versus
> #N/A.
>
> Thank you in advance.

On Fri, 10 Jun 2005 12:42:03 -0700, "carl" <carl@discussions.microsoft.com>
wrote:

>Is there a way to modify the vlookup formula so that it return a blank versus
>#N/A.
>
>Thank you in advance.


=IF(ISNA(your_vlookup_formula),"",your_vlookup_formula)


--ron

=IF(ISNUMBER(MATCH(A1,B1:B100,0)),VLOOKUP(A1,B1:C100,2,0),"")


Regards,

Peo Sjoblom

"carl" wrote:

> Is there a way to modify the vlookup formula so that it return a blank versus
> #N/A.
>
> Thank you in advance.

try =if(iserror(vlookup),"",Vlookup)


"carl" wrote:

> Is there a way to modify the vlookup formula so that it return a blank versus
> #N/A.
>
> Thank you in advance.

On Fri, 10 Jun 2005 12:42:03 -0700, "carl" <carl@discussions.microsoft.com>
wrote:

>Is there a way to modify the vlookup formula so that it return a blank versus
>#N/A.
>
>Thank you in advance.


=IF(ISNA(your_vlookup_formula),"",your_vlookup_formula)


--ron

Is there a way to modify the vlookup formula so that it return a blank versus
#N/A.

Thank you in advance.

=IF(ISNUMBER(MATCH(A1,B1:B100,0)),VLOOKUP(A1,B1:C100,2,0),"")


Regards,

Peo Sjoblom

"carl" wrote:

> Is there a way to modify the vlookup formula so that it return a blank versus
> #N/A.
>
> Thank you in advance.

try =if(iserror(vlookup),"",Vlookup)


"carl" wrote:

> Is there a way to modify the vlookup formula so that it return a blank versus
> #N/A.
>
> Thank you in advance.

On Fri, 10 Jun 2005 12:42:03 -0700, "carl" <carl@discussions.microsoft.com>
wrote:

>Is there a way to modify the vlookup formula so that it return a blank versus
>#N/A.
>
>Thank you in advance.


=IF(ISNA(your_vlookup_formula),"",your_vlookup_formula)


--ron