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
Turbo-charge your time in Excel
Used at top investment banks, Wall Street Prep's Excel Crash Course will turn you into an advanced Power User and set you apart from your peers.
![Scenario Analysis Using XLOOKUP [VIDEO]](https://media.wallstreetprep.com/uploads/2020/10/27150118/scenarioxlookup-450x338.jpg "Scenario Analysis Using XLOOKUP [VIDEO]")
