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")