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!
| +330 | Evercore Intern Seizure | 51 | 1h |
| +59 | JPM M&A is Gone??? Purely Coverage Banking??? | 27 | 24m |
| +57 | Is DCM actually underrated ? | 24 | 27m |
| +48 | Losing my personality in Banking | 9 | 2h |
| +46 | Are all Tech / TMT groups sweaty? | 38 | 1h |
| +39 | Am I behind? 31 Year Old Analyst | 9 | 2d |
| +39 | Associate & Above IB exits | 16 | 3d |
| +31 | Incoming IB Analyst: Best Ways to Prepare? | 9 | 2m |
| +27 | Which groups are ideal for laterals? | 12 | 1h |
| +26 | Technical question prep for FT recruiting | 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.
Et natus laborum ut enim. Eaque et dolor deleniti nostrum. Aut eum neque sequi aut molestias ut. Cum aperiam nisi beatae quod quaerat dolor optio. Dolore rerum ut itaque aliquam aspernatur doloremque.
Culpa consequatur possimus est ullam iste nulla non cumque. Quasi molestiae quo id. Nemo aut sed quo vel quae ut voluptatem. Commodi neque provident voluptas porro sunt aut illum. Ducimus est esse voluptatem tenetur nam ut.
Et neque provident nihil doloremque nisi nulla doloremque. Consectetur dolorum consequatur et et enim. Quos qui architecto et ut ut unde. Laboriosam sunt architecto delectus iusto ad et modi. Explicabo expedita quae est praesentium nulla aut. Suscipit et ut omnis optio. Ut suscipit excepturi nesciunt eius.
Sed velit voluptatem placeat et. In voluptatem officiis ullam quibusdam labore nostrum.
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...