Here is a bit of the data, this is what I am trying to do.
In column B I want it to return "Multi Carrier" if the cell in Column A starts with "MC", return "Choice" if the cell in A starts with "MetChoice", and return nothing if the cell in A is single carrier.
Any ideas???
Hope the example helps
Bookmarks