Index / match type problem, with partial string match

I'm attempting to create a workbook that will categorize a downloaded checking account ledger into categories based on the vendor.

In column "E" on sheet 1, the entries mostly look like this. There is some variation, but I should be able to work around it:

PURCHASE AUTHORIZED ON 12/31 Target 1234 San Diego CA X00555333468497213648 CARD 1234

On a second sheet I started a vendor list. Instance cell A2 lists "Target" and cell B2 is "Groceries"

I was trying to come up with a way to look a the entries on Sheet 1 in column E and in column F next to the entry, list "Groceries" based on the example above.

Initially I tried index match and a "*" type function, but then realized the Match lookup value I was trying to source was embedded within column E. It wouldn't make sense to do it in reverse based on the outcome I am looking for.