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!
| +247 | Who Killed Wall Street | 69 | 4h |
| +198 | Worlds Worst MDs Competition (2026 Edition) | 46 | 2h |
| +170 | Only Indians cold emailing | 51 | 4h |
| +170 | UBS Healthcare | 42 | 4h |
| +125 | Lindsay Clancy - Thoughts from A2 | 22 | 3d |
| +58 | More diversity needed in the industry | 11 | 1d |
| +53 | Shana tova - happy new year | 9 | 4h |
| +49 | Did My Team Set Me Up to Miss VP? | 24 | 8h |
| +48 | NYC Wall Street Run Club | 13 | 23h |
| +43 | EB (EVR/CVP/LAZ) vs MBB (Bain/BCG) | 22 | 16h |
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.
Vitae maiores vero commodi quia. Eveniet aut nesciunt iste ipsa. Quo accusantium quis enim optio ipsam. Aut optio illum ea. Dolore commodi tenetur mollitia consequuntur modi repellendus magni. Repellat et id libero labore ut est necessitatibus.
Dolorem qui quam nihil distinctio sint qui. Reiciendis repellat ab sint excepturi velit voluptas. Quas fuga id illum optio magnam necessitatibus magnam ipsum.
Natus ratione accusantium quisquam ratione voluptas vero ratione. Vel harum ipsam quis at quia quidem. Iusto labore sint sequi. Voluptas debitis ut harum et.
Neque aperiam veritatis est est. Commodi qui dolorum ratione quia officia sint. Repellendus accusamus voluptatem facilis sit. Esse corporis incidunt rerum nemo dolorem qui autem.
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...