Good Day,

I a spreadsheet that i need to return multiple catagories if certain words are matched.

For example:

C2 may contain "Kwik Trip" or "the Store" or "Hal's Supermarket". I want column D2 to return the word "Gas" if A2 has "Kwik Trip" or "the Store" anywhere in it. I want D2 to return the word "Groceries" if column A has "Hals Supermarket" anywhere in it. C2 will contain only one of the qualifiers in it. C2 will however contain more than just those words IE: "KWIK TRIP GAS AND GO" or "THE STORE BREAD AND BUTTER STOP".

I have tried using the formula =if(c2="*Kwik*","Gas"),if(c2="*The Store*","Gas"),if(c2="*Hals*","Groceries") . This doesn't seem to recognize that I want a return if the partial words are met.

Thanks!!