can I use Contains() within Match()
I need to search a character column to look to see if each rows value contains specific strings and then create an indicator name/group accordingly in the new column (it will be searching for ~14 specific strings). I'm pretty sure nested IF() would be pretty slow... I have used Match() in the past when I want to match exact strings, but can I use wildcards?
I tried * and % but to no avail:
Mat...
jmpbeginner
ajgarnello