Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |