Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find multiple words in cell? | Excel Discussion (Misc queries) | |||
serach of dat | Excel Discussion (Misc queries) | |||
counting text example of a cell with multiple words inside | Excel Discussion (Misc queries) | |||
counting text example of a cell with multiple words inside | Excel Discussion (Misc queries) | |||
Search for multiple words | Excel Discussion (Misc queries) |