Excel For BusinessMany 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.

 

1 Response Comment

  • adminAugust 9, 2019 at 8:37 pm

    This function is a very powerful function. You can try it.

    Reply

Leave A Comment

Please enter your name. Please enter an valid email address. Please enter message.