I would like to find a formula that it will looking in a collumn (column B) that there are some particular words and after looking in another column (COLUMN A) to find if any of these words contained in each row of column A. But because in Column B the words are approximatelly 100 is there any formula that looks to all the collumn automatic?
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
I have make this afte consulting someone in this forum, but it is very time consuming...
=+IF(ISNUMBER(SEARCH($I$3;B3));$I$3;IF(ISNUMBER(SEARCH($I$4;B3));$I$4;IF(ISNUMBER(SEARCH($I$5;B3));$I$5;IF(ISNUMBER(SEARCH($I$6;B3));$I$6;IF(ISNUMBER(SEARCH($I$7;B3));$I$7;IF(ISNUMBER(SEARCH($I$8;B3));$I$8;"Not applicable"))))))
A | B | C | D |
1 | Inventory | Companies | Auto Complete |
2 | Aleg Indesit | Singer | Indesit |
3 | Short Singer Spring | Indesit | Singer |
4 | Long Philips / Purify | Philips | Philips |
5 | Fast Brita Elemaris | Brita | Brita |
6 | Brita / Maxtra | Balay | Brita |
7 | Food Siemens | Bauknecht | Not applicable |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
I have make this afte consulting someone in this forum, but it is very time consuming...
=+IF(ISNUMBER(SEARCH($I$3;B3));$I$3;IF(ISNUMBER(SEARCH($I$4;B3));$I$4;IF(ISNUMBER(SEARCH($I$5;B3));$I$5;IF(ISNUMBER(SEARCH($I$6;B3));$I$6;IF(ISNUMBER(SEARCH($I$7;B3));$I$7;IF(ISNUMBER(SEARCH($I$8;B3));$I$8;"Not applicable"))))))