Match

  • Thread starter Thread starter Tarig
  • Start date Start date
T

Tarig

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.
 
Hi Tarig
In sheet1,type in cell B1 the formula below.
=IF(A1=Sheet2!A1,"yes","no")
Regards
Cimjet
 
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.
 
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
 
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
 
Back
Top