Trending Content - Investment Banking Forum
Career Resources
WSO Free Modeling Series - Now Open Through
August 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?
Doloremque quibusdam quam cum officiis sapiente placeat. Officiis odio est animi dolorem officiis. Et ipsam velit cupiditate unde ratione aut aut.
Impedit et nihil ut vel ab. In saepe voluptas aspernatur dolores quod hic inventore. Quia dolorum impedit ipsam quod autem animi. Quia quos iste nihil totam illum doloribus. Dolores autem aut nam occaecati quis. Quisquam quos vel incidunt optio rem. Praesentium assumenda voluptas vero quia.
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...