if ... and if isna together?

[Bill Williams]

Hi All

1st merry Xmas and thanks for past help

Tried :
=IF(B3=(VLOOKUP(B3,'Data'!A:K,1,FALSE)),"CHK","IMPT")

Works but get some #N/A

Tried:
=IF(ISNA(B3=(VLOOKUP(B3,'Data'!A:K,1,FALSE)),"CHK","IMPT")),"IMPT",(B3=(VLOOKUP(B3,'Data'!A:K,1,FALSE)),"CHK","IMPT")

No good

Can someone put me straight please

Thanks

BW

[FDibbins]

Not exactly sure what you are trying to do, but give this a try...
=IF(ISERROR(VLOOKUP(B3,Data!A:K,1,FALSE)),"CHK","IMPT")

[Tony Valko]

Maybe this...

=IF(COUNTIF(Data!A:A,B3),"CHK","IMPT")