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
8,005
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 Your Free Trial Now

Start your free trial now, and begin learning software, business and creative skills—anytime, anywhere—with video instruction from recognized industry experts.

Start Your Free Trial Now