How to fill a cell in a dictionary?

Question

Google Sheets

How to populate a column brandusing a dictionary?

If the column contains a brand name from the dictionary, then it is filled with the brand name.

link (didn't find how to download the file)

Answer 1

As mentioned above SEARCHor FINDcan solve this problem

=ARRAYFORMULA(TRIM(TRANSPOSE(QUERY(TRANSPOSE(IFERROR(
  IF(
    FIND(TRANSPOSE(LOWER('словарь'!B2:B11));LOWER(B2:B11));
    TRANSPOSE('словарь'!B2:B11)
  )
));;9^9))))

Example https://docs.google.com/spreadsheets/d/1YxaovrYFH8...

Answer 2

An option devoid of grace and filled with restrictions.

Answer 3

An external algorithm is only to help - either a macro, or a handler on the same python.
It is necessary to compare the occurrence of a substring (brand) in a string (name). At the same time, understand that there can be several occurrences and make a choice.
No other way.

Answer 4

Or maybe just a drop-down list?)
Or do you need to find a word by word from the line in the name column and, if there is a match with the brand, write this brand into the brand column of the corresponding line?
---
Maxim Stoyanov (stomaks), developer of Google Apps Script .
g-apps-script.com
stomaks.me