Many Excel users, are familiar with some Excel Lookup and Reference Functions such as Vlookup, Hlookup, Index, Match and the Transpose function. The question I need to ask is, ” How many have considered the use of the “Indirect Function”, with capabilities to extract information from different workbooks?
Here is a video that demonstrates how to use the INDIRECT function to extract data from different worksheets.
Let me know what you think about this video. You can also check this ===>> link to see list of Excel Courses that will transform you from an Excel newbie to a master user.
This video is also included in my advanced Excel Tutorial as well as the practice workbook.