Search a cell for a specific number

[mpenkala]

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

 

[T. Valko]

Try this entered in D3:

=IF(COUNT(FIND(B3,C2)),"match","no match")

Copy down as needed

 

[HARSHAWARDHAN. S .SHASTRI]

write down following formula in cell d3

=IF(ISNUMBER(FIND(b3,c2)),"match","no match")

Harshawardhan Shastri


==========================================================

 

[Mike H]

Hi,

Put this in d2 and drag down

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

Mike

 

[mpenkala]

Thanks guys - all your suggestions worked great. (I went with T Valko's).

Appriciate the quick response.

Matt

 

[T. Valko]

You're welcome!

--
Biff
Microsoft Excel MVP

Thanks guys - all your suggestions worked great. (I went with T Valko's).

Appriciate the quick response.

Matt