Lookup and Reference Functions
Lookup and Reference Functions in Advanced Excel allows matching with criteria and retrieve the values from the database according to the suggested criteria. There are a number of functions to work individually or combinedly such as VLOOKUP, HLOOKUP, MATCH, INDEX, INDIRECT, CHOOSE, GETPIVOTDATA, etc.