Is there a way to use hlookup or index match with a lookup value that is a reference cell? As in, the look up value is a dynamic, changing value depending on, in this instance, the year that it is linked/referencing to?
I’m trying to create a summary sheet, but a dynamic one, where if the historical years change, the I/S metrics: revenue, EBITDA, so on and B/S items: Cash, debt, FCF change accordingly.
Any guidance as to how I should attack this will be TREMENDOUSLY appreciated.
Thank you!
| +129 | I think I’m logging off after ER visit | 27 | 10m |
| +114 | AI Creating More Work | 36 | 13h |
| +112 | Is it Bad That I ALREADY Don’t Care? | 32 | 10h |
| +98 | Senior Banker's Guide to IB Recruiting / Group Placement (with a Healthcare Bent) | 13 | 4h |
| +84 | Shit PWP Culture | 63 | 2h |
| +66 | Is pay at BofA really that bad? | 20 | 47m |
| +46 | How easy was recruiting for you? | 22 | 3h |
| +38 | Is the life of a VP at a 'top-bank' really good? | 12 | 8h |
| +37 | 22yo IB Analyst just had mental health breakdown | 11 | 2d |
| +22 | Law school instead of MBA for RX Banking | 3 | 2d |
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.
Asperiores quo maxime quos est nemo qui velit eaque. Rem maxime quos fuga qui. Non facere dicta quo. Qui sint qui enim dolorem repudiandae.
Maiores ex nulla possimus error consequuntur culpa. Nemo autem doloribus magni enim repellendus.
Officiis aut est ab possimus sed adipisci. Est et exercitationem pariatur quod. Sit est pariatur voluptas ipsam qui modi. Distinctio ullam quia quia.
Autem voluptatem ducimus eos maiores. Non exercitationem vero ut consectetur. Veritatis corporis aut enim praesentium.
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...