if isna and vlookup together

Hi
I have a vlookup formula where some answers are #n/a to tidy up i have used
if isna the formula is quite long is there a better way than formula below
i.e do I have to write vlookup again?
=if(isna(vlookup(a1,sheet2!a:b,2,false),0,vlookup(a1,sheet2!a:b,2,false))
Thanks
Tina

Tina,

Another way is something similar, that is test the lookup values for error

=IF(ISNUMBER(MATCH(A1,Sheet2!,A;A,)),...

not really much different.

--
HTH

Bob Phillips

"tina" <[email protected]> wrote in message
news:[email protected]...
> Hi
> I have a vlookup formula where some answers are #n/a to tidy up i have
used
> if isna the formula is quite long is there a better way than formula below
> i.e do I have to write vlookup again?
> =if(isna(vlookup(a1,sheet2!a:b,2,false),0,vlookup(a1,sheet2!a:b,2,false))
> Thanks
> Tina

=if(countif(sheet2!a:a,a1),vlookup(a1,sheet2!,a:b,2,0),0)

HTH
Jason
Atlanta, GA

>-----Original Message-----
>Hi
>I have a vlookup formula where some answers are #n/a to
tidy up i have used
>if isna the formula is quite long is there a better way
than formula below
>i.e do I have to write vlookup again?
>=if(isna(vlookup(a1,sheet2!a:b,2,false),0,vlookup
(a1,sheet2!a:b,2,false))
>Thanks
>Tina
>.
>