In this video of this Free Excel Training, you will learn about the following LOOKUP and REFERENCE formulas:br br VLOOKUP functionbr HLOOKUP functionbr INDEX functionbr MATCH functionbr OFFSET functionbr INDIRECT functionbr ROW functionbr ROWS functionbr COLUMN functionbr COLUMNS functionbr Related Excel Articles:br br VLOOKUP Vs INDEX MATCHbr VLOOKUP with multiple criteriabr Case sensitive VLOOKUPbr Use VLookup to Get the Last Number in a List in Excelbr Lookup the Second, the Third, or the Nth Value in Excelbr Find the Last Occurrence of a Lookup Value a List in Excel