problem with classification of bank transactions with a lookup table

[teemeren]

Hi all,
I have a question that I cannot find an answer to. I hope I'm posting this well, it's the first time on a forum

I'm working on something of which the image below is a simplified version. I would like to be able to classify a payment in a category, based on a table that contains the classifications.
So, for every transaction on the left, with a description and an amount, I want to check wether one of the keywords in the table is found in the desciption, and if so, fill out the classification behind the keyword that is a match.
I made it work with a switch function:

=SWITCH(A3;G2;H2;G3;H3;G4;H4;G5;H5)

that goes in C3, and is copied down. However, this only works with an exact match between the keyword and the description.
I would like to be able to find the keyword within a desciption with other variables around it, as in the second case.
I tried a lot of combinations of vlookup (as here I am able to lookup a value like "*"&G5&"*"), index and match, but I'm not able figure it out. Is it a case that is only solvable by VBA? Unfortunately I'm not skilled enough in this language to produce a solution there as well.

I hope that you guys are able to help!

with kind regards,
Tjebbe

 

[Cubist]

Try:

Book1
	A	B	C	D	E
1	bank desc	classification		keyword	classification
2	albert hejin is ok	food		ikea	house
3	ikea pasunasdj 6	house		google	automation
4	google factuerne 23123	automation		lidl	food
5	albert hjin is ok	food		albert	food
6	lidl is niet	food
Sheet2

Cell Formulas
Range	Formula
B2:B6	B2	=XLOOKUP(TRUE,ISNUMBER(SEARCH($D$2:$D$5,A2)),$E$2:$E$5)

 

[teemeren]

Thank you so much. I do not totally follow how it works, but it does do the job! Thanks again