Скачать или смотреть How to return MULTIPLE COLUMNS using XLOOKUP function in Excel?

XLOOKUP is a great alternative to the VLOOKUP function.

XLOOKUP allows you to return values from more than one column by writing the formula just once.

Learn how to use the XLOOKUP function to return multiple values based on a lookup value.

▶️ Other videos that may interest you
For a detailed explanation of XLOOKUP, please see our full video
   • How to use the XLOOKUP Function in Excel? ...  

Introduction to dynamic arrays
   • Dynamic Arrays in Excel 365: The Game-Chan...  

✅ Subscribe to our Channel to level up your Excel skills faster
   / @analyticssuccess  

⬇️ Download the file used in the video
https://www.qling.net/11174/files/66c...

💻 Courses offered by us

Learn more about our Excel Masterclass course
https://yt.qling.net/excel-masterclass

Explore all courses
https://yt.qling.net/courses

📘 Download our E-Book on Excel Shortcuts (Windows and Mac)
https://yt.qling.net/excel-shortcuts

🗂️ Access all our templates and E-Books
https://yt.qling.net/templates-and-eb...

🤝 Connect with us

LinkedIn:   / qling1  
Facebook:   / learnatqling  
Instagram:   / learnwithqling  
Pinterest:   / learnatqling  
Get in touch: https://quiz.qling.net/get-in-touch/