Forum Discussion
WassimN
Apr 05, 2026Copper Contributor
Look up two parts of a string in a cell
Hello All, I know all about the XLOOKUP() but at times I need a special type of a look up. if I have a cell with the text “Apples and Oranges” how can I write an XLOOKUP to evaluate the “Appl...
Riny_van_Eekelen
Apr 06, 2026Platinum Contributor
Wouldn't this work?