Serach for multiple words in one cell
 

Hi

In cell b4, b5 and b6I have 3 makes. In Kolum b12 up to B25 I have text in
which I want to check if one of these makes are mentioned.

Presently I have formula: =IF(COUNTIF(B12,B4),"Make X","No")

but that only allows to search for one make. Changing B4 into B4:B6 does not
work. How can I do this?

rgrdds

Robert

Serach for multiple words in one cell
 

I believe this will work for you.

=IF(ISNUMBER(MATCH(B12,B$4:B$6,0)),"Make "&B12,"No")
You can then copy downwards as far as needed.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Robert L." wrote:

Hi

In cell b4, b5 and b6I have 3 makes. In Kolum b12 up to B25 I have text in
which I want to check if one of these makes are mentioned.

Presently I have formula: =IF(COUNTIF(B12,B4),"Make X","No")

but that only allows to search for one make. Changing B4 into B4:B6 does not
work. How can I do this?

rgrdds

Robert

Serach for multiple words in one cell
 

You could do something like this:

=IF(COUNTIF(B12:B24,B4),B4&", ","")&IF(COUNTIF(B12:B24,B5),B5&", ","")
&IF(COUNTIF(B12:B24,B6),B6,"")

Hope this helps.

Pete

On Sep 14, 3:34*pm, Robert L. <Robert
wrote:
Hi

In cell b4, b5 and b6I have 3 makes. In Kolum b12 up to B25 I have text in
which I want to check if one of these makes are mentioned.

Presently I have formula: =IF(COUNTIF(B12,B4),"Make X","No")

but that only allows to search for one make. Changing B4 into B4:B6 does not
work. How can I do this?

rgrdds

Robert

Serach for multiple words in one cell
 

Hi Luke

Thanks I come close but with the formula I do not get the expected outcome.
When I change it to

=IF(ISNUMBER(MATCH(B12,B$4:B$6)),"Make "&B12,"No") -- so without the 0
after B$4:B$6 I do get an outcome, but then only the full text in which is
searced and I only want the make returned.

What do i do wrong?


"Luke M" wrote:

I believe this will work for you.

=IF(ISNUMBER(MATCH(B12,B$4:B$6,0)),"Make "&B12,"No")
You can then copy downwards as far as needed.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Robert L." wrote:

Hi

In cell b4, b5 and b6I have 3 makes. In Kolum b12 up to B25 I have text in
which I want to check if one of these makes are mentioned.

Presently I have formula: =IF(COUNTIF(B12,B4),"Make X","No")

but that only allows to search for one make. Changing B4 into B4:B6 does not
work. How can I do this?

rgrdds

Robert