Alternatively, but not ideally, I could skip referencing another table and just write everything into a formula like this:
IF(SEARCH("?utm_source=youtube&utm_medium=video”,{Input}),”YouTube”,
IF(SEARCH(“?utm_source=google&utm_medium=cpc&utm_term=tampabrand",{Input}),“Google AdWords Tampa Brand”,
IF(SEARCH("?utm_source=google&utm_medium=cpc&utm_term=implantstampa",{Input}),“Google AdWords Implants Tampa”,
IF(SEARCH("?utm_source=google&utm_medium=cpc&utm_term=implantsorlando",{Input}),“Google AdWords Implants Orlando”,
IF(SEARCH("?utm_source=google&utm_medium=cpc&utm_term=orlandobrand",{Input}),“Google AdWords Orlando Brand”,
IF(SEARCH("?utm_source=google&utm_medium=cpc&utm_term=srtampa",{Input}),“Search Remarketing Tampa”,
IF(SEARCH("?utm_source=google&utm_medium=cpc&utm_campaign=4_tampa",{Input}),“GA AllOn4 Tampa”,
IF(SEARCH("?utm_source=google&utm_medium=cpc&utm_campaign=4_orlando",{Input}),“GA AllOn4 Orlando”,
IF(SEARCH("?utm_source=google&utm_medium=cpc&utm_term=conqtampa",{Input}),“Google AdWords Conquest Tampa”,
IF(SEARCH("?utm_source=google&utm_medium=cpc&utm_term=conqorlando",{Input}),“Google AdWords Conquest Orlando”,
IF(SEARCH("?utm_source=google&utm_medium=cpc&utm_campaign=brand-us",{Input}),“Brand US”,
IF(SEARCH("?utm_source=google&utm_medium=cpc&utm_campaign=jacksonville",{Input}),“D5 Conquest”,
IF(SEARCH("?utm_source=google&utm_medium=cpc&utm_term=zygomatic",{Input}),“Zygomatic Dental Implants”,
IF(SEARCH(”?utm_source=google&utm_medium=cpc&utm_campaign=periodontal",{Input}),“Periodontal”,
IF(SEARCH(”?utm_source=bing&utm_medium=cpc&utm_campaign=ntl&utm_term=allon4",{Input}),“Bing AllOn4 US”,
IF(SEARCH(”?utm_source=bing&utm_medium=cpc&utm_term=orlandobrand",{Input}),“Bing Brand Orlando”,
IF(SEARCH(”?utm_source=bing&utm_medium=cpc&utm_term=tampabrand",{Input}),“Bing Brand Tampa”,
IF(SEARCH(”?utm_source=bing&utm_medium=cpc&utm_campaign=ntl",{Input}),“Bing National”,
IF(SEARCH(”?utm_source=bing&utm_medium=cpc&utm_term=conqorlando",{Input}),“Bing Conquest Orlando”,
IF(SEARCH(”?utm_source=bing&utm_medium=cpc&utm_term=conqtampa",{Input}),“Bing Conquest Tampa”,
IF(SEARCH(”?utm_source=bing&utm_medium=cpc&utm_term=implantsorlando",{Input}),“Bing Dental Implants Orlando”,
IF(SEARCH(”?utm_source=bing&utm_medium=cpc&utm_term=implantstampa",{Input}),“Bing Dental Implants Tampa”,
IF(SEARCH(”?utm_source=bing&utm_medium=cpc&utm_term=zygomatic",{Input}),"Bing Zygomatic“
)))))))))))))))))))))))
But this tells me it’s an invalid formula. Anyone see a problem with how I’m structuring it? I wrote it using the solution found in this thread: Nested IF(SEARCH()) Formulas
I also tried it without the brackets around Input, as in {Input}. But it still said it was invalid.