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”
| +438 | Female bankers doing brand deals on TikTok | 124 | 22m |
| +141 | UBS rolling out Enhanced Clean Desk Policy, bans deal toys | 16 | 3d |
| +99 | Starting FT in a city 3 hours away, dad has progressing Parkinson's. Looking for advice. | 8 | 1d |
| +73 | JULY 2026 CHICAGO BANK RANKINGS | 28 | 9h |
| +64 | Restructuring is paradise (a completely unbiased account) | 6 | 4d |
| +37 | Not Treated Well by Other Interns | 20 | 1d |
| +36 | Handling frustration | 5 | 4d |
| +34 | Taking days off as an intern | 17 | 38m |
| +28 | Thoughts on Intrepid - Houlihan Merger | 10 | 3d |
| +27 | IB TikTok Influencers (wehave2wizards) | 9 | 3d |
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.
Accusamus consequatur et ea velit sint sed. Nam ea dicta unde adipisci adipisci. Rerum deserunt qui temporibus eos aperiam animi voluptatum soluta. Excepturi quaerat sapiente in consequatur doloribus.
In neque illum rerum eaque corrupti. Architecto consectetur consequatur voluptas quo iusto. Ipsum et hic culpa nisi quas architecto quasi qui.
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...