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" wrote in 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
|