How to join values to changing list?

Hello,

I have 2 tables just like in this document: question 1.xlsx

I need to join values from yellow table to the appropriate noun in green table.
The problem is that nouns in green table are always in different order, for example now "Samsung" is the first in the table, but maybe tomorrow the same "Samsung" will be on the last place but I always need to have the same value for that "Samsung" as listed in second (yellow) table.


Which formula/function can do that?

I don't want macros or to click "Find and sort" tabs in Excel?