How to use INDEX and MATCH
The index and match formula is an advanced lookup which has many advantages over vlookups. It gives users the flexibility to combine horizontal and vertical matches as well as lookup multiple column or row criteria.
Return a result from a corresponding column in a table with VLOOKUP
A vlookup is a vertical lookup between two corresponding columns in a data table, where the value returned is based on the first match.