Excel Tutorial - Use FORMULAS across worksheets

Dennis Taylor, an Excel expert, has 25+ years of experience in spreadsheet authoring and training.

#Excel
#HowTo
#LinkedIn

[drewt.]

Thank you, that gets me closer to my goal. I wanted to pick and choose sheets from the same book. The sheets will not be all lined up in a row, but skipping every 3.

[wylergiordani]

This was amazing, but can you provide a video on how you would do this if the tables were not aligned? Or if the information you’re looking for is in a different row? Is there a way to use a index match across worksheets?

[MakeWayCJ]

I was trying to figure out why I never had this problem with spacing between words and found that it was because I was taught in school to use an underscore between the words. That way you can still have a visual space between the words while not letting it get in the way of the formula. I think if you try that, you could then successfully use the INDIRECT function without having to go through as much. Just a thought.

[philipmunkhondya]

Thanks bro, you just made my work easier

[colleenclark]

Thank you!!! I watched other videos and read several articles and none of them were as logical as your tutorial. You saved my day!

[oliviagrace]

For God so loved the world that he gave his one and only Son, that whoever believes in him shall not perish but have eternal life. John 3:16 <3