Hi,

Put this in d2 and drag down

=IF(ISNUMBER(FIND(B2,C1)),"Match","No Match")

Mike

"mpenkala" wrote:

Hey there,
I'm trying to do the following:
ColB contains either 1,2, or 3
ColC contains a combination of 12,21,23,32,13 or 31

What I'm looking is in ColD, to check the number in B3 and see if it's one
of the numbers in C2. So, for example:

ColB ColC ColD
1
2 12
3 23 No Match - since 3 (B3) isn't part of 12 (C2), it's a no
match
3 23 Match - since 3 (B4) is a part of 23 (C3), it's a match
1 13
2 12

Thanks!
Matt