Hi David,
You can use the Find/Replace Tool for this. At first, it doesn't seem like what you are after but if you look at the Configuration of the field, you can actually Append a field if the text is found.
So in the following simplified Module:
- The top input is the data (In this example, one column called DataToSearch containing Monday-Sunday x3).
- The bottom input is the Lookup Table (in this example, one column called Lookup containing "Monday", "Friday").
- The Formula Tool just makes a field called "Check".
Below is the configuration of the Find/Replace Tool and the Output that I then get from my Browse tool:
The way I understand your Issue, this should be what you are looking for. Let me know if it needs further explanation.
Kane