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

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

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

Hi Tarig
This formulat will compare Sheet1!A1 with Sheet2!A1 and if equal reply"Yes'
if not "NO".
Second line should be "A2 compared to A2. I am using XL2003 and works ok for
me, check the formula you got in the cell below A1 and if that don't work
test the formula on a new workbook just to see.
Regards
Cimjet
"Tarig" wrote in message
...
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

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.