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.
--
tarig


"Cimjet" wrote:

Hi Tarig
In sheet1,type in cell B1 the formula below.
=IF(A1=Sheet2!A1,"yes","no")
Regards
Cimjet
"Tarig" wrote in message
...
Hi,

I have references on sheet 1 column A and I have part of these references
on
sheet 2 column A as well. On Sheet 1 column B, I want to put "Yes" for
references on sheet 1 which match references on Sheet 2 and "No" for
otherwise.

N.B: There might be several rows with the same referece on Sheet 1, while
on
sheet 2 there is a unique reference for each raw.
--
tarig