Xlookup function

How to use Xlookup function to analyze Excel data. Using XLOOKUP, we can look in one column for a search term, and return a result from the same row in another column. The return column can be on the left or right side of the lookup value. XLOOKUP is different from VLOOKUP in that it uses separate lookup and return arrays, where VLOOKUP uses a single table array followed by a column index number. From the examples in the video below you can see how Xlookup is used in different interesting ways to analyze Excel data:

 

Further Reading:

What is Xlookup?