Excel XLOOKUP function with formula examples
![Excel XLOOKUP function with formula examples](https://cdn.ablebits.com/_img-blog/xlookup/excel-xlookup-exact-match.png)
See how to use the XLOOKUP function for vertical and horizontal lookup in Excel. It can look in any direction, return last match, perform v-lookup or h-lookup with multiple criteria, two-way lookup, and more.
![](https://www.excelmojo.com/wp-content/uploads/2022/12/XLOOKUP-Function-in-Excel-Example-1-Step-2.png)
XLOOKUP Excel Function - Examples, Formula, How To Use?
XLOOKUP vs VLOOKUP - 5 Key Differences
![](https://i0.wp.com/excelbits.com/wp-content/uploads/2022/05/XLookup-in-Excel-Basic1.png?resize=849%2C399&ssl=1)
How to use XLOOKUP function In Excel - A Complete Guide - Excel Bits
![](https://www.benlcollins.com/wp-content/uploads/2022/08/XLOOKUPInGoogleSheetsSimpleExampleNoHighlights-1.jpg)
XLOOKUP Function in Google Sheets
![](https://images.saymedia-content.com/.image/t_share/MjAwODk3MjA0NzkyMDc1NDY4/how-to-use-the-xlookup-function-in-excel.png)
How to Use the XLOOKUP Function in Excel - TurboFuture
![](https://assets-global.website-files.com/61f27b4a37d6d71a9d8002bc/6498712d3cf8cdee22788435_Screenshot%202023-06-25%20at%2010.23.44%20PM.png)
XLOOKUP Function in Excel: Explained
![](https://exceldashboardschool.com/wp-content/uploads/2023/10/XLOOKUP-match-text-contains.png)
Excel XLOOKUP function with formula examples - Definitive Guide
![](https://blog.coupler.io/wp-content/uploads/2022/09/Excel-XLOOKUP.png)
Excel XLOOKUP - The Advanced LOOKUP Function
![](https://blog.coupler.io/wp-content/uploads/2021/07/8-xlookup-formula-example-1024x524.png)
Excel XLOOKUP - The Advanced LOOKUP Function
![](https://support.content.office.net/en-us/media/d1b2c44f-adec-472f-8f68-44a58a3f4bfe.jpg)
XLOOKUP function - Microsoft Support