Excel 2016: MATCH And INDEX Functions
4,800 views · Published 13 August 2017 · 4:19 · Indexed 14 November 2026
Channel: Kirt Kershaw · 2017 · Education
Excel 2016 tutorial on the MATCH function which will return a numerical representation of a value's place in a single row or column, or vector; and is often used to return an item's row number for the use in another lookup function like the INDEX function. The INDEX function returns the value in a row and/or column of a cell range. All 160 of my Excel 2016 training videos contain everything you need to help pass both the Microsoft Office Excel 2016 Core (77-727), and Expert (77-728) exams and become certified! PATREON: Kirt Kershaw & Dream Force, LLC invite you to subscribe for the $2 monthly option which includes ALL Microsoft Office training tutorials 2016, 2013, 2010 and 2007. New videos will be constantly uploaded to Patreon so you will get new content: Visit and sign up at: https://www.patreon.com/KirtKershaw DVD & DOWNLOAD AVAILABLE: https://www.DreamForce.us SUBSCRIBE to learn more Microsoft Office tips, tricks and shortcuts! http://www.youtube.com/subscription_center?add_user=videotrainingpro LET'S CONNECT! -- http://www.facebook.com/KirtKershaw -- http://www.linkedin.com/in/kirt-kershaw-33874410
More from this channel
-
5:42
Windows 7: Basic Overview
-
6:27
Excel 2010 Print Rows Top Each Page - Repeat Column Headers Training Video
-
4:14
Excel 2010 Evaluate and Watch Formulas Training Video
-
5:04
Word 2010 Document Views Training Video
-
0:30
PowerPoint 2010 Introduction Training Video
-
2:56
Project 2013 Reschedule Task Training Video
-
9:51
Excel 2013 Essential and Basic Training Video
-
4:33
Excel 2013 Evaluate and Watch Formulas Training Video