| 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 |
| 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) | |||
Threaded Mode
