Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search for specific number in a range | Excel Worksheet Functions | |||
Search for a number in a table and return data of a specific cell | Excel Discussion (Misc queries) | |||
Search for record with specific name in a cell | Excel Worksheet Functions | |||
How do I search for specific text and sum the cell to the right? | Excel Worksheet Functions | |||
Search for a specific character in a cell in an if statement | Excel Worksheet Functions |