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:
~
=XLOOKUP("best day ever", days, you)
#xlookup #excel