Uploaded July 2025 | Updated November 2026, 1 day ago
Want to learn XLOOKUP? You have come to the right place.
"XLOOKUP is probably the most powerful XL function" - my grandma
How to use XLOOKUP?
=XLOOKUP(
value you want to find,
in the column where your data is,
specify the column you want as a result)
XLOOKUP Example 1:
=XLOOKUP(
"Richard",
B8:B42,
H8:H42)
XLOOKUP Example 2:
=XLOOKUP(
"EMP1012",
C8:C42,
B8:B42,
"Person not found")
Why use XLOOKUP?
XLOOKUP is an easy, versatile and powerful XL function that let's you search what you want in your data and get matching results. It is better version of VLOOKUP and INDEX+MATCH functions.
In this 6 minute video, learn how to use XLOOKUP in Microsoft Excel.
The video explains:
✅ How to use XLOOKUP?
✅What happens when XLOOKUP can't find the value?
✅XLOOKUP and returning the entire row
✅XLOOKUP with two sheets
More Excel XLOOKUP examples and explanation:
Read my detailed XLOOKUP article for full information - chandoo.org/wp/xlookup-examples
XLOOKUP Sample file - chandoo.org/wp/wp-content/uploads/2025/07/xlookup-howto.xlsx
XLOOKUP Advanced Techniques (10 powerful examples) - youtu.be/YyhJe5tMq58
I stopped using VLOOKUP, here is why - youtu.be/DDlZXXEI1bU
~
=XLOOKUP("best day ever", days, you)
#xlookup #excel
Want to learn XLOOKUP? You have come to the right place.
"XLOOKUP is probably the most powerful XL function" - my grandma
How to use XLOOKUP?
=XLOOKUP(
value you want to find,
in the column where your data is,
specify the column you want as a result)
XLOOKUP Example 1:
=XLOOKUP(
"Richard",
B8:B42,
H8:H42)
XLOOKUP Example 2:
=XLOOKUP(
"EMP1012",
C8:C42,
B8:B42,
"Person not found")
Why use XLOOKUP?
XLOOKUP is an easy, versatile and powerful XL function that let's you search what you want in your data and get matching results. It is better version of VLOOKUP and INDEX+MATCH functions.
In this 6 minute video, learn how to use XLOOKUP in Microsoft Excel.
The video explains:
✅ How to use XLOOKUP?
✅What happens when XLOOKUP can't find the value?
✅XLOOKUP and returning the entire row
✅XLOOKUP with two sheets
More Excel XLOOKUP examples and explanation:
Read my detailed XLOOKUP article for full information - chandoo.org/wp/xlookup-examples
XLOOKUP Sample file - chandoo.org/wp/wp-content/uploads/2025/07/xlookup-howto.xlsx
XLOOKUP Advanced Techniques (10 powerful examples) - youtu.be/YyhJe5tMq58
I stopped using VLOOKUP, here is why - youtu.be/DDlZXXEI1bU
~
=XLOOKUP("best day ever", days, you)
#xlookup #excel



![Excel for Managers [FREE Masterclass]
Do you work as a manager and use Excel? Then this live stream is for you. In this informative, useful and incredibly time-saving session, learn the most impactful Excel concepts & tricks that matter to you.
📂 Sample file: https://chandoo.org/wp/wp-content/uploads/2025/03/sample-file-done.xlsx
#excelformanagers #excel Excel for Managers [FREE Masterclass]](https://i.ytimg.com/vi/elbXQRARrhw/mqdefault.jpg)






