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
|