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?

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

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


GHawkins wrote:

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

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?

It works great! Thanks!!!!

"Dave Peterson" wrote:

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

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


GHawkins wrote:

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

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?

You're welcome!

Biff

"GHawkins" wrote in message
...
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?