How to Use Excel XLOOKUP and XMATCH Functions
HTML-код
- Опубликовано: 18 май 2022
- 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:
ruclips.net/user/simonsezittra...
If you enjoyed the video, please give a thumbs up 👍🏽 ;-) Наука
🔥Check out our FREE 300+ hour training course playlist here ➡
ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
🚀Level up your Excel skills with this free playlist 👉ruclips.net/p/PLzj7TwUeMQ3jhT7yg37LKe8aSTA7OuWn3
& here 👉ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc
Extremely clear and precise; very helpful.
Thank you very much for the explanation, very well explained and useful...
Glad it was helpful!
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).
what is we have more than 2 Google Docs?
Use xlookup with multiple criteria.. use &
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])
Wow, thanks for the knowledge sharing!
Thank you @RipRoarLB! This is exactly what I was looking for. 💜💙💚💛🧡
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.
use sumifs formula
What if I want to see all the matches
Filter
😁😁😁😁😁❤