I have the below two (shortened) tables:
A1:A5 - Data table
URL
shop.samsung.com/au/accessories/mobile-accessories
samsung.com/us/amp/us/smartphones/galaxy-s9
samsung.com/us/appliances/electric-ranges
samsung.com/global/business/semiconductor/minisite/SSD/notice.html
E1:F5 - Reference Table
If Folder Contains Value
mobile-accessories Mobile Accessories
smartphones Mobile Phone
appliances/electric-ranges Cooking Appliance
appliances/refrigerators Semiconductor
I'm trying to create a formula that will look at the URL table, check if the string has a partial match in the Reference table's "If Folder Contains" column, and return the Value. For example, if I choose the first link (A2) I would expect the formula to return "Mobile Accessories" since A2 contains "mobile-accessories" in the URL.
The reverse I know how to do (simply do a vlookup with a wildcard before/after), but I can't figure out a way to do this. Any guidance will be appreciated