How to Use Excel XLOOKUP and XMATCH Functions

No video

How to Use Excel XLOOKUP and XMATCH Functions

Рет қаралды 48,858

2 жыл бұрын

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 150+ courses ⏩ www.simonsezit.com/courses/
🚀 Level up your skills with a free 30-day trial to our complete training library of 8,500+ videos ⏩ www.simonsezit.com/ssit-first...
💻 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.com/
LinkedIn: / simon-sez-it
FaceBook: / simonsezit
🔔 Subscribe to our channel:
kzfaq.info...
If you enjoyed the video, please give a thumbs up 👍🏽 ;-)

Пікірлер: 15

@SimonSezIT Жыл бұрын

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

@emet744 Жыл бұрын

Extremely clear and precise; very helpful.

@donavanthomas1747 7 ай бұрын

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).

@maxdeniel 2 жыл бұрын

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

@SimonSezIT 2 жыл бұрын

Glad it was helpful!

@bobbychan2086 3 ай бұрын

Use xlookup with multiple criteria.. use &

@RipRoarLB 3 ай бұрын

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 3 ай бұрын

Wow, thanks for the knowledge sharing!

@izabellan9706 Ай бұрын

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

@ahmadullahazizi3038 Жыл бұрын

what is we have more than 2 Google Docs?

@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 4 ай бұрын

use sumifs formula