Search a cell for a specific number
 

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

Search a cell for a specific number
 

Try this entered in D3:

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

Copy down as needed

--
Biff
Microsoft Excel MVP


"mpenkala" wrote in message
...
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

Search a cell for a specific number
 

write down following formula in cell d3

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

Harshawardhan Shastri


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

"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

Search a cell for a specific number
 

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

Search a cell for a specific number
 

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

Appriciate the quick response.

Matt


"T. Valko" wrote:

Try this entered in D3:

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

Copy down as needed

--
Biff
Microsoft Excel MVP


"mpenkala" wrote in message
...
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

Search a cell for a specific number
 

You're welcome!

--
Biff
Microsoft Excel MVP


"mpenkala" wrote in message
...
Thanks guys - all your suggestions worked great. (I went with T Valko's).

Appriciate the quick response.

Matt


"T. Valko" wrote:

Try this entered in D3:

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

Copy down as needed

--
Biff
Microsoft Excel MVP


"mpenkala" wrote in message
...
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