So I am using an if function to try and pull certain phrases from and column. Ideally I want to pull certain keywords from a big phrase and have it classify them in a different column.
Right now I am using the following (just a piece of a longer formula):
if (H:H="MC","Multi Carrier",if(H:H="MetChoice","Choice".....)
And an example of an entry in column H would be MC - Liberty, Travelers
Or something similar to that. But when it runs the formula it returns nothing because it is looking for an exact match of "MC" or "Metchoice". How do I get the formula to see if the phrase includes either of those, and return the correct keyword.
This would be a huge help, thank you!
Rob
Bookmarks