match 2 columns

[adityatandel]

Col 1 Col 2 Match
111111 00000111111 Y
222222 00000222222 Y
233444 00000356455 N

what is the formula to get the Y and N in the match field?

 

[shemayisroel]

Could you confirm if any of the numbers are in TEXT format?

Also, would there always be 5 leading 0's?

 

[shemayisroel]

Actually try this in C1 to assess values in A1 & A2

C1 and copy down

=IF(VALUE(B1)=A1,"Y","N")

This will work even if the values in Column B are are in TEXT

 

[Aladin Akyurek]

Also...

=IF(A1-B1=0,"Y","N")