Align an item name from its short description via keywords

Hi,

So I'm trying to figure out a better way to align brands names from its products descriptions.

Right now I'm using a simple =if(is.number(search(A1;B1));A2;....)

An example in the attachement (mostly colums H and sheet - dictionary)

Ideally i would love to just select whole columns in the dictionary tab and let excel search keyword and then align the brand name.

BR!

Anyone please help !

I am pretty sure this can be done with idices / vlookup, however I just can't think of a way to incorporate this in my formulas