Learn how to perform lookups with multiple criteria in Excel 365 using XLOOKUP and INDEX & MATCH. This tutorial walks you through setting up a dynamic table that allows you to select a month and a company from dropdown lists to retrieve specific sales data.

Get unlimited training with Simon Sez IT’s 200+ courses https://www.simonsezit.com/courses/

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! https://simonsezit.lpages.co/ssit-14-day-free/

Watch more free popular training tutorials from Simon Sez IT:

Check out our FREE 400+ hour training course playlist here
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

For a full training experience, check out our FREE YouTube course: https://www.youtube.com/@SimonSezIT/courses

Microsoft Excel Tips and Tricks https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc

Microsoft Office 2021 and Office 365 Training here https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hH_MxteY6LR3OSMHpDkt_j

Stay in touch!
SimonSezIT.com: https://www.SimonSezIT.com/
LinkedIn: https://www.linkedin.com/company/simon-sez-it/
FaceBook: https://www.facebook.com/SimonSezIT

Subscribe to our channel:
https://www.youtube.com/simonsezittraining?sub_confirmation=1

If you enjoyed the video, please give a thumbs up ;-)