Forum Discussion

WassimN's avatar
WassimN
Copper Contributor
Apr 05, 2026

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...