Lookup Formula?

[Guest]

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?

 

[Dave Peterson]

One way:
=if(isnumber(match("*" & a1 & "*", b:b,0)),"T","F")

Another:
=if(countif(b:b,"*" & a1 & "*")>0,"T","F")

 

[Biff]

Try this:

=IF(COUNTIF(B$2:B$5,"*"&A2&"*"),"T","F")

Biff

 

[Guest]

It works great! Thanks!!!!

One way:
=if(isnumber(match("*" & a1 & "*", b:b,0)),"T","F")

Another:
=if(countif(b:b,"*" & a1 & "*")>0,"T","F")

 

[Guest]

It works great! Thanks!!

Try this:

=IF(COUNTIF(B$2:B$5,"*"&A2&"*"),"T","F")

Biff

 

[Biff]

You're welcome!

Biff

It works great! Thanks!!