Download Excel File: https://ift.tt/2JKax13
Entire page with all Excel Files for All Videos: https://ift.tt/1kSFWvs
In this video see 4 different formulas to lookup a cell reference.
Topics:
1. (00:06) Introduction
2. (00:33) Formula #1: MATCH Function
3. (01:55) Formula #2: ADDRESS Function with MATCH & COLUMN Functions
4. (03:08) Formula #3: ADDRESS Function with MATCH, ROW & Column Functions
5. (04:11) Formula #4: CELL Function with INDEX and MATCH functions to lookup a cell reference
6. (05:32) Formula Evaluator to cell how formula calculated
7. (05:58) Conclusion