Hi,
I need a formula fix and review, to lookup a value (description) and then return a grouped up value.
I tried using vlookup & xlookup with wildcard, but the result not what I wanted.

Based on keyword in G or J, it will return H or K after find it from B.
It seems able to return a value if the B is 1 word. My sample excel as attached.

sample.xlsx

Capture.PNG