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!
| +182 | UBS Accused of Favoring H-1B Workers While Cutting U.S.-Born Employees | 44 | 1h |
| +77 | IB Energy Drink Tier List / Ranking | 52 | 1h |
| +70 | PJT M&A Group Selection 2026 | 13 | 5h |
| +36 | Quick Thoughts on CVC AI Sale Process | 7 | 3d |
| +33 | Feedback for internship first desk at IBD BB - personal fit, "don't be too confident" | 23 | 20h |
| +27 | Does BofA still pay its associates rat pellets? | 11 | 3h |
| +24 | ONLY THESE BANKS OR YOU STRUCK OUT | 6 | 7m |
| +19 | Updated JPM Group Rankings | 28 | 2h |
| +18 | What happened to Greenhill | 8 | 3d |
| +18 | VP Deal Origination Credit | 2 | 4h |
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.
Repudiandae dolores officia quaerat placeat. Provident magnam consectetur ratione quo ipsa consequuntur. Temporibus id impedit neque.
Dolorem quia aliquam quo ad impedit. Quo in ducimus dolores nihil debitis aut. Qui at explicabo quis voluptatem laboriosam autem. Voluptatem repellendus minus animi earum tempora deserunt laudantium.
Earum necessitatibus voluptas aut et assumenda enim aliquam. Beatae rerum minus illum repellendus qui quam quia. Asperiores doloribus molestias eum sit ea unde. Dolor quo quod neque cum fugit ullam. Deserunt at sit minima. Vero amet tempora explicabo voluptatem.
Adipisci eius enim magnam et quia assumenda autem iure. Quis veniam blanditiis nobis sint aut. Velit distinctio repellendus doloribus illum repellendus. Non ea sint doloremque cumque temporibus placeat.
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...