Function XLOOKUP in Excel How to use the XLOOKUP function of Excel? It's a combination of the VLOOKUP and INDEX functions. Look at this article.
Split your text on a delimiter – TEXTSPLIT Function The new TEXTSPLIT function allows you to split the content of your cell on a delimiter. It's very easy to use.