After struggling for some time I found a partial solution but it does not work all the time.
In a nutshell, I have rows with text derived from Point of Sale program which contain descriptions of the restaurant orders.
First, I need to derive specific words from the test string:
and then I need to break the orders into French and Indian choices based on those derived words. I have a corresponding categories to each derived word. So, if the word is "Florence" then the category should be French, if it is "In" then Indian.
The problem with the LOOKUP formula i am using is that sometimes it returns the wrong words. Foe example, if the cells says "Florence entry in macadamia sauce" it will derive the word "in" instead of "Florence".
thank you so much for anyone trying to help me