You don’t provide a direct link
The speed at which information can be toggled is significant to being able to measure investments
If the tab being referenced to by the formula, and a row on that tab gets added to that tab and the cell referenced in the formula will not “pick it up”
| +152 | How to stop feeling like shit for not making it in IB? | 57 | 47m | |
| +115 | If Tik Tok is forced to sell, what banks do you think would be involved in the deal? | 58 | 24m | |
| +80 | Updated LA Banking Scene (2024) | 57 | 20m | |
| +38 | Ranking banks that went under | 20 | 5h | |
| +34 | Burnt Out M&A ASO | 18 | 3h | |
| +32 | A strategy for SA applicants late to the game like myself | 15 | 12h | |
| +29 | Relevance of A-Levels for U.K. London recruiting | 21 | 17h | |
| +26 | Series 79 Help / Tips to Pass The First Attempt | 11 | 2d | |
| +26 | Intern Ettiquette | 4 | 15h | |
| +23 | What are hours like at BBs in London? | 47 | 14h |
Career Resources
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.
Please swing by.
While I agree with the inconvenience/danger of not being able to trace, just use an indirect index match match to make more dynamic and avoid issues of adding cells. Not much better way to consolidate 100 unit-level p&ls other than that
Can you “drag down” though?
To drag down with INDIRECT you have to use the “ROW” formula inside - would there be a way INDEX MATCH + ROW + INDIRECT could be dragged down?
You don’t need to use Row at all. That’s why I said indirect index match MATCH. If you include enough rows in your index area, you’ll be Gucci. Be warned though, too many of these with too large index areas can slow your file down to a crawl.
I have one summary tab that links to 8 different tabs that pulls in all the resource streams. For each 8 tabs there are PDP, PDNP, DUC, WIP, and DEV volume streams that are projected monthly to 2085. There are thousands of rows with each different starting points. The reason I used INDIRECT(column letter, cell in summary tab with same row number as the other tab) is to keep the model fast when you drag down the formula or add type curve areas.
Dangerous because if you went to any of the 8 tabs and changed a row then the summary tab would get blown up because the indirect formula isn’t actually linking to the correct tab.
Blanditiis voluptatem sit nesciunt in saepe. Nihil est voluptatibus alias quo occaecati saepe enim. Asperiores commodi est in omnis magni.
Facere repellat maxime animi eveniet tempore libero. Numquam et expedita sed dolores. Corrupti cumque dolore omnis aliquam.
Dolorum praesentium vitae quis non magnam quia non. Possimus expedita quod expedita quam ex. Consequuntur culpa fuga quo molestiae expedita. Dolor minus vitae eveniet doloremque incidunt corporis. Eaque sapiente neque vitae dolorem.
Dolore sed corporis recusandae omnis eum qui. Id fuga hic et beatae dignissimos aspernatur deserunt. Vitae et velit ipsa magnam qui iste numquam. Et aliquid est rerum ut incidunt.
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...