Webcast #4 INDIRECT Function - Gather Data From Multiple Tabs

www.TheExcelU.com
In this webcast I review how to pull data from multiple tabs using the INDIRECT Function. You will learn how this function can be used to reference sheet tab names to retrieve a specific cell from multiple worksheets.
Please be sure to checkout our other webcast at www.TheExcelU.com
Please be sure to connect with me on LinkedIn: www.MikeOnLinkedIn.com

[@vmr8974]

you are the Genius. Thanks a lot for the you explain. i was looking for this answer when sheet name has space. thanks a lot . wish you good luck

[@rockguitarist8907]

You earned a new subscriber. This video helped me get what another video was trying to explain. Yours was clearer for this section. Thank you.

[@bbnykis]

Excelent video. Thanks a ton.

[@prprprprsprs]

Thank you so much. It made the work so easy.

[@deepk82]

Very good technique, it's one of the strong formula in excel

[@apichart123]

Very useful , Thank you that i lookink for.

[@vulcanscorpio]

If I added a sumif to this indirect function, will it still drag/fill down and across? I created a formula which works well but won't fill/drag. I have a feeling it has to do with too many ampersands but I am honestly not sure. Essentially I am trying to do a 3-d sum if (avoiding using VBA).

[@angelclarke1942]

This doesnt work for me getting #REF! error

[@trujay7280]

very useful...

[@PALLAB58]

Thank you

[@InsideMyWall]

Suppose in the last sheet, Jan is repeated twice and i want to find the sum dynamically, how to integrate indirect with sumifs in that case??

[@HongKong1842]

I found out a problem. Although the rand and rank functions work well on my simple quiz excel sheet (selecting random questions for users), the content change every time when a user only edit an answer field.
This is not only annoying but also messing up the answer corresponding to the original question. Is there a way to stop refreshing please? Thanks a lot for comment.

[@MrFill]

Can you do the same but in google sheets?

[@soglowbus3862]

I DON'T KNOW BUT ITS NOT WORKING IN MY EXCEL

[@headshottock]

Hi guys if im on Google sheets and My tabs are numbers, it doesn’t work. Any advice

[@brianb4642]

Can anyone venture a guess as to why i might be getting #REF errors when trying to do exactly this?

[@abhi1988ify]

same here!

[@morganmunizza1880]

since when is ! a quote?

[@sandeepchavan455]

Next time make video visible that we can see it