INDEX MATCH in Excel (A better Lookup alternative in Excel)
Learn how to use the Index and Match functions in Excel instead of VLOOKUP and HLOOKUP.
Excel Mastery Courses for Beginners:
Complete Microsoft Excel Mastery Course for Beginners on Skillshare
https://skl.sh/2mND2Sa
Complete Excel Mastery for Beginners on Udemy
https://www.udemy.com/course/how-to-u...
About this Excel tutorial video:
Index and Match work together much like the Vlookup and Hlookup functions in Excel. They have the advantage of being able to work across an array of data as well as being able to continue working even if you change or rearrange data.
Thanks so much for learning with me. I hope to see you in another video or course soon!
Sincerely,
Steve
Other Courses by Steve McDonald:
Microsoft Access Mastery for Beginners
https://www.udemy.com/course/microsof...
Photoshop for Beginners
https://www.udemy.com/course/photosho...
This Microsoft Excel tutorial for beginners is helpful for Excel 2010, 2013, 2019 and Microsoft Office 356.