Microsoft Excel 2021365 - Beginner to Advanced - Performing Two-Way Lookups

This video tutorial covers advanced lookup and reference functions in Excel, focusing on two-way lookups using INDEX, MATCH, and the new XLOOKUP function. It explains how to prepare data, create data validation lists, and construct formulas for efficient data retrieval based on two criteria: month and company. The tutorial provides step-by-step guidance on using these functions to perform accurate and efficient lookups in Excel.

What new insight or understanding did you gain from this video?

Evaluate responses using AI:

OFF