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.
