Match Challenge

[frankee_gee]

Hello Mr. Excel,

Please help. I receive a report with about 50 rows of data daily. Two of the headings have to be identical. I was hoping I could use a formula to do this for me.

A	B	C (Want results here)
Activity Date	Transaction Date	Match yes / no
1/1/2014	1/1/2014	y
1/2/2014	1/3/2014	n
1/6/2014	1/6/2014	y

<tbody>
</tbody>

It does not have to be a "Y" or "N" ...just something that indicates that there is a mismatch. like a "1" or "0"...


Thanks for your time.

Frank.

 

[vogel997]

=if(a2=b2,"Y","N")

 

[vlady]

or
=--(A1=B1)
or for true/false
=A1=B1

 

[JoeMo]

Assuming you want to see if the entries in A have a match in B:
In C2 and copy down.

=IF(ISNA(MATCH(A2,$B2:$B100)),"No","Yes")

Adjust the B range to suit.

 

[frankee_gee]

V, V & J,

Beautiful!!! They all worked. Thanks for you help as usual. This will save tons to time.

Thanks again,

Frank.