To read the accompanying article to this video, go here https://www.simonsezit.com/article/using-xlookup-in-excel-tutorial/

In this Microsoft Excel tutorial, we look at the XLOOKUP function in Excel.

XLOOKUP is a new lookup function in Excel. If you have ever used (and struggled with) INDEX and MATCH or VLOOKUP to perform complex lookups, then XLOOKUP is a notable alternative solution.

Use the XLOOKUP function when you need to find something in a table or range by row. For example, look up a product using the product ID, or find the price of a trip using the trip code.

XLOOKUP’s power comes from being able to look in one column for a search term and return the result from the same row in another column.

XLOOKUP is more flexible than other popular lookup functions like VLOOKUP. VLOOKUP limits you to only being able to find something in a table or cell range that is in a column to the right of the search term. XLOOKUP can return results no matter where they are in relation to the search term.

GET FOUR FREE COURSES ️ https://www.simonsezit.com/four-free-courses

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

Level up your skills with a free 30 day trial to our complete training library of 8,500+ videos ⏩ https://www.simonsezit.com/ssit-first-month-free

Check out our Excel 2021 tutorials for beginners playlist here
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jqRlmIaj6jb_X9EGQueMDb

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

Watch more popular tutorials from Simon Sez IT:

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

Microsoft Office 2019 Training Tutorials for Beginners playlist
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3i2OE0G9fSMaVjcW4qi_z_7

PivotTable training here https://www.youtube.com/playlist?list=PLzj7TwUeMQ3iJ5hWG_iZuIvFvnuJJ-mtc

Stay in touch!
SimonSezIT.com: https://www.SimonSezIT.com/
StreamSkill.com: https://StreamSkill.com/
YouTube Channel: https://www.youtube.com/user/simonsezittraining
LinkedIn: https://www.linkedin.com/company/simon-sez-it/

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

If you enjoyed the video, please give a "thumbs up" and subscribe to the channel ;-)