How to Use Excel XLOOKUP and XMATCH Functions

In this Microsoft Excel 2021 training tutorial video, learn how to use the XLOOKUP and XMATCH functions in Excel. Learn how to look up values from a table or range with more flexibility than VLOOKUP with this short tutorial video!
🌍 Get unlimited training with Simon Sez IT’s 200+ courses ⏩ www.simonsezit...
🚀 Supercharge your skills with a FREE 14-day trial to our extensive training library. Learn from 10,000+ ad-free videos and begin your transformation today! ➡️ simonsezit.lpa...
💻 Watch more free popular training tutorials from Simon Sez IT:
🔥Check out our FREE 300+ hour training course playlist here ➡️
• Simon Sez IT Long Trai...
✅ Check out our free video playlist for Excel beginners 👉 • Microsoft Excel Beginn...
✅ Excel 2021 Tutorials for Intermediate Users here 👉 • Excel 2021 Tutorials f...
✅ Microsoft Excel Tips and Tricks 👉 • Microsoft Excel Tips a...
✅ Microsoft Office 2021 and Office 365 Training here 👉 • Microsoft Office 2021 ...
💬Stay in touch!
SimonSezIT.com: www.SimonSezIT...
LinkedIn: / simon-sez-it
FaceBook: / simonsezit
🔔 Subscribe to our channel:
www.youtube.co...
If you enjoyed the video, please give a thumbs up 👍🏽 ;-)

[@SimonSezIT]

🔥Check out our FREE 300+ hour training course playlist here ➡ kzbin.info/aero/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀Level up your Excel skills with this free playlist 👉kzbin.info/aero/PLzj7TwUeMQ3jhT7yg37LKe8aSTA7OuWn3 & here 👉kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc

[@sunxero8321]

Bravo bravo bravo! As soon as you pressed enter to close the formula for Profit I was like WOW! My work will be so much easier from you sharing this. Thank you.

[@SimonSezIT]

Glad to hear that the formula made things easier for you! 😃 Learn more Microsoft Excel Tips and Tricks here ➡️ kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc

[@emet744]

Extremely clear and precise; very helpful.

[@meltra2812]

thank you so much! you just saved me so much time!

[@SimonSezIT]

Glad it was helpful! 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️ kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc

[@maxdeniel]

Thank you very much for the explanation, very well explained and useful...

[@SimonSezIT]

Glad it was helpful!

[@JcaBlacksheep]

this is good, however, in the 2nd example with google doc in the "utility" category. the formula returned the correct value b/c the category was "productivity". if you had changed the category to "utility", it would have returned the correct value w/o doing the (-1, look up from bottom to top).

[@pmexplore]

What functions can use to add the two google docs revenue? Vs If I want to create a sub group with google docs and another item and get its total review aggregated sum?

[@RipRoarLB]

The most efficient way to do a two-column needed match is to concatenate the look up value and the look up array: Xlookup(B5&B6, TableName[App]&TableName[Category])

[@SimonSezIT]

Wow, thanks for the knowledge sharing!

[@izabellan9706]

Thank you @RipRoarLB! This is exactly what I was looking for. 💜💙💚💛🧡

[@graceisraa]

If I want to lookup for Google Docs which is represented twice and I want to pick up both revenue ($17,990.00 & $50,000.00) instead of only one, how do I apply this function.

[@neronjp9909]

use sumifs formula

[@vrborn2njoy]

@@neronjp9909 Sumifs will give you the Sum for Multiple criterias...here if you want details for both rows where you have google docs , better way i think is use the Filter Function

[@ahmadullahazizi3038]

what is we have more than 2 Google Docs?

[@bobbychan2086]

Use xlookup with multiple criteria.. use &

[@patrickmathias2591]

What if I want to see all the matches

[@basketballer852]

Filter

[@abdiwalimoalinahmed8323]

😁😁😁😁😁❤