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.
new excel function
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.