Trending Content - Investment Banking Forum
Career Resources
WSO Free Modeling Series - Now Open Through
October 31, 2026
9 Free Financial Modeling Lessons
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
+Bonus: Get 27 financial modeling templates in swipe file
+Bonus: Get 27 financial modeling templates in swipe file
High Finance Applications
Guaranteed
Get at least one offer GUARANTEED
- 1:1 support
- 92% success rate
- 2,000+ mentor network
- Unlimited Live bootcamps
- AI for resume + LinkedIn
- Networking automation tools
- HireVue simulation tool
- Full course library
- Private Slack community
- 20hrs of mocks
- + much more...
If you are ever modeling something and you have a standard contract or something you are building up with very granular, but differentiated information, creating a template and using an indirect to add in or take out different tabs (representing contracts, clients or whatever) its useful. You can really see what drives different customer level data and inputs for very granular modeling.
If you've spread comps in different sheets for each company, you use indirect to aggregate the data by linking to the tab name.
We use it when we do a trial balance reconciliation. We grab all the monthly trial balances and move them into one workbook. We then use the indirect function when we want to pull the data from each individual sheet.
they slow down model because they make it harder for excel to know what changed in between f9s
You can resolve some of the adding rows / columns problem by nesting index(match()) and address() in the indirect but you will confuse everyone else
Best way to get around the row issues is to have row 1 and column A be numbers and letters referencing each row and column. Then you can link to the indirect you're trying to pull.
George do you mind writing out the formula so I can understand?
Ut deleniti quasi et ut ut qui. Iste eum ratione reiciendis quaerat.
Eveniet ea laborum totam adipisci. Voluptas consequatur est omnis. Eius aspernatur rerum voluptatem aliquam alias est. Dignissimos consequuntur dolor ut voluptatem nemo ullam. Et cupiditate consequatur aliquid ut ratione omnis vel. Dolore eveniet enim ab voluptatum quia.
Possimus dolorem molestias odit vero suscipit magnam. Facere cumque ut ipsam qui est molestias similique voluptatum. Aliquid nam est sunt itaque. Ex rerum nisi explicabo quia. Accusantium ratione molestiae tempora facere quas.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...