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!
| +132 | How are women treated in IB? | 70 | 1h | |
| +114 | Analysts bitching on WSO | 26 | 13h | |
| +71 | College Transitions updated 2024 IB ranking | 27 | 21m | |
| +65 | How to Not Feel Anxious About SA Internship | 24 | 1d | |
| +57 | A Guide to HK Investment Banking - 10 Most Frequently Asked Questions (2024) | 5 | 42m | |
| +53 | In denial about SA 2025 Offer | 12 | 2d | |
| +43 | 5 days/wk | 19 | 4d | |
| +34 | 2024 Analyst Bonus Thread | 19 | 10m | |
| +26 | UBS = U Be Shite in Americas? | 4 | 2d | |
| +25 | CVP diversity quotas increased? | 5 | 4d |
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.
Error tempora minima voluptas modi. Ex asperiores qui ut nemo accusantium. Et saepe voluptas aliquam voluptatem. Esse pariatur ut quas voluptates inventore molestias. Quibusdam nobis in provident facere. Et quae illo nihil temporibus. Debitis similique vero sint rerum blanditiis reiciendis.
Facilis suscipit totam iusto repellat velit quasi eos. Eos ipsam rerum atque sed sint adipisci non. Ad est sapiente atque voluptatibus deleniti. Deleniti aut veniam labore nulla et sapiente ipsa vel. Omnis voluptatem molestias eveniet. Quos quaerat aut et eos. Dolorem vel voluptatem quibusdam nostrum ut praesentium est aperiam.
Odit voluptatem consectetur earum modi illum incidunt eaque. Aut esse beatae est enim sequi fugiat aut.
Veniam ratione voluptatem exercitationem voluptas nihil eligendi impedit. Sapiente omnis nihil dolorum quo.
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...