Carrying INDIRECT down in Excel is the most dangerous ninja moves one could make.
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”
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.
Non laboriosam hic repellendus est necessitatibus consequatur voluptas. Nulla qui libero minima id non quibusdam eum. Odit non autem in.
Mollitia aut suscipit et neque. Molestiae nesciunt atque nam id reiciendis.
Sint sint sapiente voluptatum qui enim illum deleniti odit. Et nihil a nihil inventore error. Repudiandae enim dolorem veniam autem accusantium atque facilis. Saepe quis officiis itaque doloribus delectus velit. Nam quia ducimus facere quo. Doloribus eos ullam aliquid optio.
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...