Match

[Xavie]

In columns A & B in ascending order I have the following

A B
1 200801 200700
2 200830 200701
153 208905 200830
200 209006 208905

In column C I want a formula that "match" or "not match column A with B

Regards
Carl

 

[Reeza]

In columns A & B in ascending order I have the following

       A            B
1     200801  200700
2     200830  200701
153 208905  200830
200 209006  208905

In column C I want a formula that "match" or "not match column A with B

Regards
Carl

Define Match?
Do you want if the value in A2 is matching the value in B2?
OR do you want if the value in A2 is somewhere in the BXXX list?
Or do you want if the value in B2 is somewhere in the AXXX list?

 

[Xavie]

the value in A2 is somewhere in the BXXX list

Define Match?
Do you want if the value in A2 is matching the value in B2?
OR do you want if the value in A2 is somewhere in the BXXX list?
Or do you want if the value in B2 is somewhere in the AXXX list?

 

[Duke Carey]

Assuming your data starts in row 1, in cell C1 enter

=countif(B$1:B$200,A1)

and copy it down. If the value in A1 appears in column B, the result will
be 1 or greater.

 

[Reeza]

the value in A2 is somewhere in the BXXX list






- Show quoted text -

=if(countif(B$1:B$200, A1)>=1, "MATCH", "NOT MATCH")