How to use INDEX and MATCH Functions in Excel?
This Tutorial Covers: The Basics of INDEX and MATCH Function 1.1 INDEX Function 1.2 MATCH Function 1.3 INDEX and MATCH Function Together How to Use INDEX and MATCH Function in Excel 2.1 Two-way lookup 2.2 Left lookup 2.3 Case-sensitive lookup 2.4 Closest Match 2.5 Multiple criteria lookup 2.6 INDEX MATCH with MAX, MIN and AVERAGE …
