I want to do a partial comparison and return a value if one of a bunch of values are found

This is to make may taxes easier....
I want to have a list (like a credit card or band transaction) and look in the list for certain words in another list, and if a given word from that list is found, to return what category that word is tied to.


Example
1/1/2018 Amz xxxxxxx 78.23
1/2/2018 city Shell xxxxxxx 19.25
1/4/2018 xxx Staples xxxx 20.90
1/6/2018 Safeway 12.20
1/6/2019 x Staples xxxx xxx 42.01

Match cat
Amz Office Supplies
Shell Auto Fuel
Staples Office Equipment

And the results should be like:
1/1/2018 Amz xxxxxxx 78.23 Office Supplies
1/2/2018 city Shell xxxxxxx 19.25 Auto Fuel
1/4/2018 xxx Staples xxxx 20.90 Office Equipment
1/6/2018 Safeway 12.20
1/6/2019 x Staples xxxx xxx 42.01 Office Equipment

How could I do something like this? I would like to have the match and cat list as dynamic...

Thanks!
Mc
Tax cat

Very close!
The top data is actually 3 columns, and I just wanted the results, not the field & results (that is just a matter of removing the "A2 &". (Looks like the columns got skewed....)

It got me what I want and I want to thank you VERY much!

I got it from here!

Again, Thank you! I actually have MANY uses for this, but it will help ALL my taxes in the future much easier and I will remember you EACH time!

Cheers!
Mc