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://exceldashboardschool.com/wp-content/uploads/2023/10/XLOOKUP-match-text-contains.png)
Excel XLOOKUP function with formula examples - Definitive Guide
![](https://www.spreadsheetweb.com/wp-content/uploads/2018/11/VLOOKUP-Example-1.png)
Excel VLOOKUP Function with Formula Examples
![](https://exceluser.com/wp-content/uploads/2021/09/example-01.png?6bfec1&6bfec1)
Excel's XLOOKUP Function Explained
![](https://support.content.office.net/en-us/media/25529a29-8f61-4a71-92c0-f5d7b280641e.jpg)
XLOOKUP function - Microsoft Support
![](https://assets-global.website-files.com/628cb4acdaf9087cd633cc6b/64a92368f1d36ea8d917df92_Screenshot%202023-07-08%20at%2009.47.02.webp)
Xlookup Function Excel: Definition and Examples
![](https://cdn-adclh.nitrocdn.com/zciqOWZgDznkuqFpvIJsLUeyHlJtlHxe/assets/images/optimized/rev-8cfa674/trumpexcel.com/wp-content/uploads/2020/02/XLOOKUP-function-to-do-a-simple-lookup.png)
Excel XLOOKUP Function: All You Need to Know (10 Examples)
![](https://exceldashboardschool.com/wp-content/uploads/2023/09/XLOOKUP-function-Excel.png)
Excel XLOOKUP function with formula examples - Definitive Guide
![](https://support.content.office.net/en-us/media/d1b2c44f-adec-472f-8f68-44a58a3f4bfe.jpg)
XLOOKUP function - Microsoft Support
![](https://www.avantixlearning.ca/wp-content/uploads/2023/03/excel-xlookup-function-formula-reverse-lookup-example-using-table.png)
How to Use the XLOOKUP Function in Excel (Overview, Syntax + Formula Examples)
![](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://www.contextures.com/images/functions/excelxlookupfunction01.png)
Excel XLOOKUP Function Examples
![](https://cdn.shortpixel.ai/spai/w_1082+q_lossy+ret_img+to_webp/tenuki.com/wp-content/uploads/2020/09/XLOOKUP-Function-Arguments.jpg)
What Is And How to Use XLOOKUP in Excel - tenuki courses
![](https://d3mm2s9r15iqcv.cloudfront.net/en/wp-content/uploads/old-blog-uploads/excel-example-xlookup-data-set.png)
How To Use the XLOOKUP Function in Excel [Step-by-Step]