Skip navigation

Look up values based on two criteria

Look up values based on two criteria: Google Sheets: Advanced Formulas and Functions
Look up values based on two criteria: Google Sheets: Advanced Formulas and Functions

In the previous video, you learn how to create a flexible and powerful lookup formula using INDEX and MATCH. In this video, extend that approach and learn how to do a lookup from a rectangular cell range using the same two functions.

Resume Transcript Auto-Scroll
Skill Level Intermediate
3h 11m
Duration
28,490
Views
Show More Show Less
Skills covered in this course
Business Data Analysis Spreadsheets Google Sheets

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