The string in say A4 contains +golf
so therefore it also contains golf
Right?

The function is returning the last item from C2:C44 that it found within the string in A4 (golf)

You need to arrange your values in C2:C44 in order of priority when dealing with more than 1 matching value.
If you would prefer to see +golf instead of just golf, then put the +golf AFTER golf.


Hope that helps.