Try this play

In Sheet1,
Assuming data in A2 down
Put in B2:
=IF(A2="","",IF(ISNUMBER(MATCH(A2,Sheet2!A:A,0))," Yes","No"))
Copy down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Tarig" wrote:
Hi Cimjet, your formulae only worked when A1 in sheet1 matchs A1 on sheet 2
and when I copy the formulae down to match other references it is not giving
what I am expecting.