Lookup Formula?
It works great! Thanks!!
"Biff" wrote:
Try this:
=IF(COUNTIF(B$2:B$5,"*"&A2&"*"),"T","F")
Biff
"GHawkins" wrote in message
...
I'm trying to come up with a lookup formula for the following example:
Column A Column B
Row 1 22k b22kcw
Row 2 23k bf23kc
Row 3 32k b25kce
Row 4 28k be32kw
In Column C, I want a formula that looks at the value in A2, compares it
to
column B, and if it finds "22k" anywhere in one of the values, it returns
T.
If it doesn't, it returns F. I have a formula working when the values are
side by side (Row 1), but not when they are not (Row 3 and 4). Is this
possible?
|