HOW TO USE XLOOKUP FUNCTION WITH MULTIPLE RETURNS BY EXCEL IN A MINUTE

🤔 ABOUT THIS Lesson 👇
HOW TO USE XLOOKUP FUNCTION WITH MULTIPLE RETURNS BY EXCEL IN A MINUTE
Welcome to Excel in a Minute!
Introduction
In this part of the script, we should be able to answer the question: What is this lesson?
Other Excel lookup functions can give you 1 return value only. However, the X LOOKUP function can give you multiple return values from a single formula.
In this video, we will show you a quick demo on how to return multiple values using X LOOKUP.
In this part, answer the question: When and where can the lesson be used?
The X LOOKUP is a function that searches a value from a horizontal or vertical array, then returns a value from a specified return array.
The function runs on six arguments where only the first three are required.
In this lesson, we will focus on the return array. In X LOOKUP, the number of columns or rows in the return array indicates the number of return values.
To return multiple values, you must include multiple columns for vertical lookup, or rows for horizontal lookup as the return array. However, note that this will only work if the columns or rows are positioned side-by-side.

_________________________________________________________________________________________________

🤓 VIEW THE BLOG POST (in here you can download the presentation and the excel file) 👇

/

to download the files go to the bottom of the BLOG POST and press the download button

___________________________________________________________________
🔔 SUBSCRIBE TO EXCEL IN A MINUTE ON YOUTUBE 👇

___________________________________________________________________
💥FOLLOW EXCEL IN A MINUTE ON SOCIAL MEDIA 👇

___________________________________________________________________
🤔 ABOUT EXCEL IN A MINUTE 😃

ABOUT US
Excel can be Challenging , but EXCEL IN A MINUTE has simplified it for you. In less than 3 minutes, our videos will help you learn Excel tips and tricks faster than you have ever imagined. Learning is fast, skills are retained for life.
New Excel tutorials are released twice a week. Subscribe to our channel to be notified of new videos

📚 RECOMMENDED RESOURCES 👇

If you found this video valuable, give it a like.
If you know someone who needs to see it, share it.
Leave a comment below with your thoughts.
Add it to a playlist if you want to watch it later.

DISCLAIMER: The information contained on this YouTube Channel and the resources available for download/viewing through this YouTube Channel are for educational and informational purposes only.​

This description may contain affiliate links. If you purchase a product through one of them, I will receive a commission (at no additional cost to you). I only ever endorse products that I have personally used and benefitted from personally. Thank you for your support!

#excelinaminute, #Msexcel,#excelintuitive,#msexcel,