Match
 

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

Match
 

On Sep 3, 1:10*pm, Xavie wrote:
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?

Match
 

the value in A2 is somewhere in the BXXX list

"Reeza" wrote:

On Sep 3, 1:10 pm, Xavie wrote:
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?

Match
 

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.

"Xavie" wrote:

the value in A2 is somewhere in the BXXX list

"Reeza" wrote:

On Sep 3, 1:10 pm, Xavie wrote:
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?

Match
 

On Sep 3, 1:50*pm, Xavie wrote:
the value in A2 is somewhere in the BXXX list



"Reeza" wrote:
On Sep 3, 1:10 pm, Xavie wrote:
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?- Hide quoted text -

- Show quoted text -

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