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