The_Rock
Board Regular
- Joined
- Jul 2, 2007
- Messages
- 174
Hi Folks
Been racking my brains trying to find a solution for this.
In Column A, I have a bunch of Sentences which is basically a description field.
In order to meet criteria, somewhere in the sentence, it needs to state the following "Government Disclosure Complete". As I'm working with different countries across Europe, their spelling isn't always the same.
For example, I have created a list of acceptable terms which is:
governement disclosure complete
government disclosure compleet
Customer has been advise
Goverment desclosure notified
Customer is aware
Customer has been notified
Goverment disclosure notified
PS disclosure completed
Customer disclosure complete
I am trying to create a sort of wildcard vlookup that will search thru column A, if it can make a partial match to one of the above words, it will then return a simple yes or no answer.
Appreciate your help with this
Been racking my brains trying to find a solution for this.
In Column A, I have a bunch of Sentences which is basically a description field.
In order to meet criteria, somewhere in the sentence, it needs to state the following "Government Disclosure Complete". As I'm working with different countries across Europe, their spelling isn't always the same.
For example, I have created a list of acceptable terms which is:
governement disclosure complete
government disclosure compleet
Customer has been advise
Goverment desclosure notified
Customer is aware
Customer has been notified
Goverment disclosure notified
PS disclosure completed
Customer disclosure complete
I am trying to create a sort of wildcard vlookup that will search thru column A, if it can make a partial match to one of the above words, it will then return a simple yes or no answer.
Appreciate your help with this