One Useful Excel Lookup Functions Ignored By Many Excel Users
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.
This function is a very powerful function. You can try it.