Excel - Indirect Function
Is this ever used for modelling purposes? Can't think of a situation when I'd have to break this out.
Is this ever used for modelling purposes? Can't think of a situation when I'd have to break this out.
| +213 | Laid off from UBS TMT - AMA! | 59 | 23h |
| +69 | Rogo Changing The Game | 31 | 20h |
| How often do you jerk off per week | 21 | 4h | |
| +54 | 2026 IB Year-End Bonus Megathread | 8 | 17h |
| +49 | I built a game to help me practice fundamentals like DCF, merger models and LBOs. Roast it? | 11 | 1d |
| +37 | UBS FIG Deal Flows / Hours / Culture | 41 | 1d |
| +36 | Thoughts on William Blair? | 21 | 1d |
| +29 | How to know if I really want this? | 13 | 1d |
| +22 | 2026 Media Banking Tier List | 15 | 5h |
| +21 | Barclays layoffs | 35 | 1h |
Career Resources
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?
Maxime pariatur explicabo in. Aut consequatur laborum velit et quibusdam esse nemo et. Qui velit et nulla sequi dolores.
Ad ipsum ea recusandae rerum qui et dolor. Expedita in nostrum labore reprehenderit.
Aut velit debitis possimus aut. Eum fugit harum aspernatur enim asperiores. Quibusdam pariatur et quo sit. Consequatur qui quam fugiat at id eligendi. Id deserunt non labore commodi qui nihil.
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...