Table Array with Wildcard involving partial URL match

My dataset features many variations of URLs such as:
somewebsite.com/en-us/city/amelia-island
somewebsite.com/en-us/city/anna-maria-island
somewebsite.com/en-us/city/boca-grande

and

somewebsite.com/en-us/listing/lake-buena-vista
somewebsite.com/en-us/listing/lake-placid
somewebsite.com/en-us/listing/lakeland

and
somewebsite.com/golf/listing/fort-pierce
somewebsite.com/golf/listing/fort-walton-beach
somewebsite.com/golf/listing/miami



I need to map to a field called SITE, for example:
somewebsite.com/golf/listing/fort-pierce = GOLF CITY
somewebsite.com/golf/listing/fort-walton-beach = GOLF CITY
somewebsite.com/en-us/listing/lake-buena-vista = CITY LISTING
somewebsite.com/en-us/listing/lake-placid = CITY LISTING
somewebsite.com/en-us/city/anna-maria-island = CITY DETAIL
somewebsite.com/en-us/city/boca-grande = CITY DETAIL

So in the TABLE ARRAY, I put
somewebsite.com/golf/listing/* = GOLF CITY
somewebsite.com/en-us/listing/* = CITY LISTING
somewebsite.com/en-us/city/* = CITY DETAIL

Hoping that a LOOKUP would understand that it should return the SITE. But it doesn't work.

I spent a couple of hours searching support sites like this one, but cannot find an example that is similar enough to be useful to me.

I'm hoping some kind soul here will help.

Thank you in advance!

Thanks but this can't be right? I need a LOOKUP or INDEX/MATCH.

Uploaded a spreadsheet with dataset and in-process mapping.

On the MAPPING tab, I used red to highlight where I need wildcard matching.

For Excel Forum.xlsx

My bad! It seems my original post was not complete enough. Thank you for trying!