IMPROVING THE INDEX MATCH WITH THE SWITCH FUNCTION IN EXCEL BY EXCEL IN A MINUTE

🤔 ABOUT THIS Lesson 👇
IMPROVING THE INDEX MATCH WITH THE SWITCH FUNCTION IN EXCEL
The combination of the INDEX and MATCH function has been proven efficient over time, but this duo always gets better!
And this time around, it’s improved by the SWITCH function.
So, stick around and learn how to reinvent the INDEX and MATCH duo
Welcome to Excel in a Minute!
What is this lesson all about?
The combination of the INDEX and MATCH function has been proven efficient over time, but this duo always gets better!
And this time around, it’s improved by the SWITCH function.
So, stick around and learn how to reinvent the INDEX and MATCH duo.
When and where can the lesson be used?
Before jumping into the worksheet, let’s review the syntax for each function.
INDEX returns a value inside a table, or an array and it runs on three arguments - array, row index number, and column number.
On the other hand, MATCH searches for a specific value in a range and returns the relative position of the value in the range.
Moreover, MATCH has four arguments - lookup value, lookup array, and match type.
Lastly, SWITCH evaluates an expression against a list of values and returns a value that matches the expression.
And it runs on four arguments also - expression, value, result, and default result.
_________________________________________________________________________________________________
🤓 VIEW THE BLOG POST (in here you can download the presentation and the excel file) 👇
excelintuitive...
to download the files go to the bottom of the BLOG POST and pres the download button
___________________________________________________________________
🔔 SUBSCRIBE TO EXCEL IN A MINUTE ON KZbin 👇
/ @excelinaminute
___________________________________________________________________
💥FOLLOW EXCEL IN A MINUTE ON SOCIAL MEDIA 👇
Instagram ► / excelintuitive
Facebook ► / excelinaminute
LinkedIn► / excel-in-a-minute
___________________________________________________________________
🤔 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
Website ► www.excelintuitive.com
📚 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 KZbin Channel and the resources available for download/viewing through this KZbin 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, #indexmatch, #switch

[@abdelkrimmesaiahmed662]

Thank you for this video, there is easy way to do this, instead to use switch function use index with area number