Partial Match Microsoft Excel Vlookup - Help Needed

I have a table in Excel which contains a number of keywords (circa 250,000).

I would like to perform a partial match vlookup (sheet 1) against a list of 'brands' (sheet 2).

Please note I do NOT require an exact match vlookup. I know how to do this.

Instead, one of the keywords might be: "Nespresso Coffee Machine"

However, in the brand list, the brand is: "Nespresso".

Therefore, I need you to write a formula which allows me to look at the keyword against the list of brands, before output that the brand is "nespresso".

If the keyword in Sheet 1 contains a brand, then the name of the brand should be copied into another cell (in this case, Nespresso).

Should be straightforward.