With the your range in A1:A5 and the word in C1, put this
in B1 and fill down:
=IF(COUNTIF($C$1,"*"&A1&"*"),"found","")
HTH
Jason
Atlanta, GA
-----Original Message-----
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
.
|