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

C

C

cyberlain2021-05-06 17:32:16

excel

cyberlain, 2021-05-06 17:32:16

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

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?

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)

K

kiberlain, 2021-05-06
@cyberlain

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

Similar questions

M

Max2017-09-20 13:19:33

Is there a system of surveys accessible by link, where there is a branched survey structure? 0Reply

T

TechNOIR2017-09-22 10:22:05

csv, excel. How to properly export html code to csv cell? 1Reply

2

25hp2017-10-04 19:25:21

How to take the value of a cell that is 3 rows to the left of it? 2Reply

R

Ruslan Bagautdinov2017-10-09 15:25:31

How to make a column with time from 00:00:00 to 23:59:50? 2Reply

M

Michael2017-10-11 22:22:13

Does Excel VBA Application.ScreenUpdating affect applications? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question