How to Use Excel XLOOKUP and XMATCH Functions
46,122
Publicado 2022-05-19
🌍 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-month-free
💻 Watch more free popular training tutorials from Simon Sez IT:
🔥Check out our FREE 300+ hour training course playlist here ➡️
• Simon Sez IT Long Training Courses
✅ Check out our free video playlist for Excel beginners 👉 • Microsoft Excel Beginner's Training T... …
✅ Excel 2021 Tutorials for Intermediate Users here 👉 • Excel 2021 Tutorials for Intermediate...
✅ Microsoft Excel Tips and Tricks 👉 • Microsoft Excel Tips and Tricks
✅ Microsoft Office 2021 and Office 365 Training here 👉 • Microsoft Office 2021 and Office 365 ...
💬Stay in touch!
SimonSezIT.com: www.SimonSezIT.com/
LinkedIn: www.linkedin.com/company/simon-sez-it/
FaceBook: www.facebook.com/SimonSezIT
🔔 Subscribe to our channel:
youtube.com/simonsezittraining?sub_confirmation=1
If you enjoyed the video, please give a thumbs
Todos los comentarios (11)
-
🔥Check out our FREE 300+ hour training course playlist here ➡
youtube.com/playlist?list=PLzj7TwUeMQ3hsADWJd2sJh4…
🚀Level up your Excel skills with this free playlist 👉youtube.com/playlist?list=PLzj7TwUeMQ3jhT7yg37LKe8…
& here 👉youtube.com/playlist?list=PLzj7TwUeMQ3gv7nwM6ad7r5… -
Extremely clear and precise; very helpful.
-
Thank you very much for the explanation, very well explained and useful...
-
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).
-
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])
-
what is we have more than 2 Google Docs?
-
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.
-
What if I want to see all the matches
-
😁😁😁😁😁❤