XLOOKUP has been crowned the new king of Excel reference functions, even defeating the mighty index match.
But it’s not a complete victory. Here is an example of Index Match (more accurately – INDEX XMATCH) doing something that XLOOKUP cannot:
Download the Excel file that goes with this lesson