Excel Magic Trick 1501: INDIRECT Function: Pull Data from Different Sheet Based on Row Number

In this video learn how to use the INDIRECT Function to pull Data from a Different Sheet Based on Row Number.

[BillSzysz]

Thanks for explaining how the INDIRECT function works :-))
I am used to avoiding volatile functions wherever i can, so in the most cases i use construction with INDEX.
In this case it would be something like this.
=INDEX('Source Data'!$B:$B, B3)
Thanks for video!!!

[jaycbrand]

Thank you for this video. Saved me! Had NO idea how to do this! Thank You!

[bamakaze]

It's taken me three years to finally understand how and when to use the indirect function. I've watched many of your and other's videos, but today was the day I ran into a situation at work that required it. Of course I came straight back to your channel. Thank you Grandmaster Mike!

[rodrigocustodio]

Thank you, Mike, you are in fact the number one contributor to the sharing of Excel knowledge in the world.

[manoharchaudhary]

Sir all your videos are great, there is no match for them, can not find this type of teaching anywhere else in YouTube or even in paid classes. Thank you so much.

[Jung-samanhudisound]

Thanks Mike. That's very clear explanation for INDIRECT. I can just refer to this video if anyone ask me about INDIRECT. Can't wait for the next video.

[UnhingedHarry]

Nice and simple explanation.. thanks, and ride on !!

[nsanch]

I can never get enough of the text functions. Thank you for the excel trick Mike!

[smartshanu]

Great thanks Mike! I have seen other YouTube videos on indirect function, but the way you explained it, it's simple and more precise. Thanks again. I have now better understanding of indirect function and it's utility.

[Darkslide]

I have ALWAYS wondered how to do that, thank you so much. I learned INDIRECT from you when it came to looking up tables that were designated using the Name tool, but never thought of it in this manner.

[chrism]

Haven't really used the INDIRECT function much, so this was great Mike!

[ronametung]

This solved my problem.. thanks a lot!!!

[ismailismaili]

Amazing thank you so much to the one who asked the question and thank you of course Mr. Mike for helping him to solve it a great trick thanks a lot and don't forget you are always the king

[johnborg]

Thanks Mike and Bill Szysz. This is Great!!! :)

[DougHExcel]

another great tip for the INDIRECT function!

[mohamedchakroun]

Thanks to this indirect tricks theses reviews allows us to be efficient :-)

[pmsocho]

I would go with the INDEX function but INDIRECT is also useful in some cases :)
Thumbs up anyway :)

[ireoluwaadegoke]

Thanks for the video. How do I reference in a master sheet the same cell number in multiple rows in different sheets using the drag down + sign. For example, I want to automatically add the cell C3s in sheets A, B and C.

[lucysam]

Hello Sir ExcellsFun, How are you? Happy New Year. I found this video and was extremely excited to learn the format that you shared. I do have a query if during the month and or week, I transfer money from checking to savings and or received refunds from purchases, can you share how the formula can be modified to do so? I really appreciate and look forward to seeing that video.
Sincerely
New Viewer

[GeertDelmulle]

OK, this one was easy. Thanks. I’m curious where you’re gonna take this next...