How to find a word from a list in a table cell and display it?

Question

excel

There are many positions in the table from the supplier without indicating the manufacturer's brand, but it may be present in the product name. Actually, you need to take a line from a cell and check if it contains a word from the range with brands. How to do it?

Answer 1

=ПРОСМОТР(2;1/ПОИСК(brands;B2);brands)