Download Excel Start File: https://ift.tt/30JEza7
Download Excel Finished File; https://ift.tt/2xW8n7g
In this video have fun with silly and inefficient formulas to do a Two-Way Lookup using: 1) the INDEXT and MATCH Functions and the Space Operator and 2) the Defined Name Feature, The INDIRECT Functions and the Space Operator. Both formulas are for fun because there are more efficient formulas as seen in these videos:
Excel Two Way Lookup with VLOOKUP & MATCH Functions – Excel Magic Trick 1567
Excel Two Way Lookup with INDEX & MATCH Functions – Excel Magic Trick 1568
https://www.youtube.com/watch?v=TaLc6ZToY3Q