How to use INDEX and MATCH | Exceljet
https://exceljet.net/articles/index-and-match
WEBSummary. INDEX and MATCH is the most popular tool in Excel for performing more advanced lookups. This is because INDEX and MATCH are incredibly flexible – you can do horizontal and vertical lookups, 2-way lookups, left lookups, case-sensitive lookups, and even lookups based on multiple criteria.
DA: 92 PA: 63 MOZ Rank: 30