=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,vlook up
(a1,sheet2!a:b,2,false))
Thanks
Tina
.