About this tutorial:
Video duration: 13:10
In this Excel tutorial I show you how to lookup values from multiple Excel Sheets or tabs. In Excel it’s relatively easy to lookup values in one specific tab. But how do you lookup values in multiple tabs using just one single formula?
In the video, I show you different versions of getting this done. One version uses VLOOKUP and direct worksheet and cell references. The other version uses INDEX & MATCH and Excel table names and references. The key here is the INDIRECT function which acts as the messenger which returns the correct address to the different lookup formulas.
Of course, you…