| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Function to determine if any cell in a range is contained in a given cell
Is there an Excel function that can determine if any value in a range
is contained in a given cell. Ex Range - CC, DD, EE, FF, QQ Cell - Yabbadee Desired function would indicate that EE was found in cell (last 2 chars of Yabbadee). VLOOKUP would not indicate that EE was found in the cell (exact match required). If the cell value however was CC, DD, EE, FF, or QQ it would find a match. TIA |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| function cell range limitations | Excel Worksheet Functions | |||
| Displaying value of specific cell within a range, with IF function...? | Excel Discussion (Misc queries) | |||
| How can I shift cell range contents by using a function? | Excel Worksheet Functions | |||
| which formula or function searches for a value in a range of cell. | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
