In this video of this Free Excel Training, you will learn about the following LOOKUP and REFERENCE formulas:

VLOOKUP function
HLOOKUP function
INDEX function
MATCH function
OFFSET function
INDIRECT function
ROW function
ROWS function
COLUMN function
COLUMNS function
Related Excel Articles:

VLOOKUP Vs INDEX MATCH
VLOOKUP with multiple criteria
Case sensitive VLOOKUP
Use VLookup to Get the Last Number in a List in Excel
Lookup the Second, the Third, or the Nth Value in Excel
Find the Last Occurrence of a Lookup Value a List in Excel