Hi
Hope you can help me. I have a list in Column A. The list is a sample of a much longer one. Specific words or a combination of two words appear anywhere in the cell as you can see in column A. Column A is the original list. I'm looking to separate the list into three columns: The Outlet (B), the Charge Type(C) and either "Allowance" or "Disc"(D). In columns H, I and J I gave each range a dynamic name because if any word does not appear within those ranges they should not appear in columns B, C or D. I have left empty cells in each range so I can add words if the need arises.
Somehow I feel VLookup is the solution, but I could be wrong. I'll leave up to you.
I'd appreciate your feedback.
Many thanks
patish
Bookmarks