Hello all
I just signed up to this forum and was trying to find a solution for my problem in the previous posts and questions, but unfortunately I cannot find anything.
So I am hoping someone can help me with the following problem:
I have a list of values, in which I am searching for certain phrases. If the phrase if found I want to assign the category which I have assigned to this. The phrase I am looking for, can be anywhere in the cell.
Description Category #Jan-20 - FX Clearing - posted FX Feb-20 - FX Clearing FX
My lookup table would look like the following:
Value Category FX Clearing FX Clean-up CHECK PH1 PH1
I hope it is halfway clear, what I am trying to do here and thank you very much for your help in advance.
P
Bookmarks