Excel Magic Trick 1504: Lookup Cell Address: 4 Examples: MATCH, ADDRESS, CELL function?

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

View on YouTube

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.