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”
| +205 | Who Killed Wall Street | 65 | 17h |
| +177 | Worlds Worst MDs Competition (2026 Edition) | 35 | 11h |
| +164 | As Lehman people reconvene at UBS, Barclays needs to hire (2023) | 23 | 4d |
| +121 | Lindsay Clancy - Thoughts from A2 | 22 | 1d |
| +59 | How bad did I mess up | 11 | 1d |
| +46 | NYC Wall Street Run Club | 9 | 1h |
| +43 | EB (EVR/CVP/LAZ) vs MBB (Bain/BCG) | 21 | 1d |
| +34 | Most technical groups? | 18 | 1d |
| +21 | Meritocratic IB groups / banks | 15 | 3d |
| +18 | Life After IB: Off-Track Career Ideas, Questions & Musings | 0 | 2h |
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.
Et maxime aut sint excepturi. Provident cumque ipsa ut consequatur. Pariatur minus aut eum 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...