Forum Discussion
xLookup if contains text
I tried this formula but it doesn't work I want to return specific value when containing specific text
To return the Crown word and I am using this formula because when sentence contains any of these words, I want to return the crown word
- Still not working as I want. I need to fix the issue in my formula in the above attached excel
