Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Excel’s # 1 Silliest Formula: INDEX or INDIRECT? Excel Magic Trick 1571 (Two Way Lookup Trick)

Posted on by Annie D

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

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.