Skip navigation

Use the MATCH and INDEX LOOKUP functions

Use the MATCH and INDEX LOOKUP functions: Cert Prep: Excel 2013 Microsoft Office Expert Part One (77-427)
Use the MATCH and INDEX LOOKUP functions: Cert Prep: Excel 2013 Microsoft Office Expert Part One (77-427)

Learn how to nest the MATCH function with INDEX. Author Jen McBee demonstrates how to use these functions to first find the row on which the value is located, and then nest that information in an INDEX function to get the desired result.

Resume Transcript Auto-Scroll
Skill Level Advanced
2h 42m
Duration
118,056
Views
Show More Show Less

Continue Assessment

You started this assessment previously and didn't complete it. You can pick up where you left off, or start over.

Start My Free Month

Start your free month on LinkedIn Learning, which now features 100% of Lynda.com courses. Develop in-demand skills with access to thousands of expert-led courses on business, tech and creative topics.

Start My Free Month