Learn all about the new XLOOKUP Function in Excel!

XLOOKUP in Excel

INDIRECT function in Excel

You can download the workbook here to follow along with the Video!

In this video, we speak about the XLOOKUP Function, we explain how the function works, and also we compare it against VLOOKUP & HLOOKUP.

We speak about the following points:

1- XLOOKUP vs VLOOKUP
2- XLOOKUP vs HLOOKUP
3- How to perform Two-way lookup with XLOOKUP
4- How to perform Lookups with multiple criteria using XLOOKUP
5- How to do approximate match lookup with XLOOKUP (The bonus calculation problem) and the extra options that we have when using XLOOKUP. We also speak about the binary search option
6- How to search Last to first (Bottom to top) using XLOOKUP.
7- Wildcard Match using XLOOKUP
8- Dynamic Ranges using XLOOKUP
9- XMATCH Function

We also show how to accomplish different tasks that we used to accomplish using the other legacy functions such as VLOOKUP, HLOOKUP, INDEX & MATCH combo using XLOOKUP . We also speak about the XMATCH Function.

Please share

If you like this post, don’t forget to Share it with your friends on different social media platforms using the share buttons!

Ace your Excel Career by learning how to create Excel Dashboards!

Learn Step by Step how to create Professional, Interactive Dashboards & Charts using Excel including:

1- Learning the Important functions that you need to know for building Dashboards such as VLOOKUP, HLOOKUP, MATCH, INDEX, OFFSET and others

2-Learning how to implement Interactivity tools such as Form Controls, Slicers, and others.

3-Learning Dashboarding techniques.

4- Building a Complete Excel Dashboard.

Click here Find out more

This is one of the most helpful and comprehensive dashboard classes I have taken. I was able to take what I learned in the evening and apply it at work the next day. I created a compensation dashboard and my boss was amazed! Thank you Abdelrahman Abdou for an awesome class.

Mary Templin

By |2019-09-27T10:40:00-05:00September 27th, 2019|Uncategorized|0 Comments

About the Author:

Hello, I'm Abdelrahman, the founder of Excelbonanza.com I'm an Excel enthusiast and Data Analyst with 7 years of Experience in the Telecom and Customer service industry. I'm here to share my knowledge with the world and help people become better at Excel!

Leave A Comment

Send this to a friend