Trending Content - Investment Banking Forum
Career Resources
WSO Free Modeling Series - Now Open Through
July 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?
Aut ut nihil ut quidem quibusdam iure. Laborum qui assumenda omnis id at. Ut rerum fugit modi consequuntur eum sed nesciunt.
Commodi repellendus nostrum beatae. Ut distinctio quis error rerum quam vero. Natus doloremque exercitationem molestiae dicta.
Dolorem est accusamus amet nihil. Vel dolorem et et dolores et dolorem.
Quidem facilis soluta optio quae. Dolor voluptatem et quibusdam ullam voluptatem rerum. Cumque fugit sunt iste ab. Aut quae odio ea distinctio unde. Corporis non deleniti delectus veniam deserunt tempora dolores. Similique pariatur et nihil in nemo quis magnam.
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...