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!
| +249 | Earliest you can get fired | 46 | 36m |
| +233 | Are target prospects getting dumber? | 44 | 54m |
| +224 | MBB Pay Raises | 47 | 55m |
| +209 | Career Crossroads | 25 | 59m |
| +207 | US 2027 SA IB worried about background check | 47 | 53m |
| +201 | UBS’s M&A BANKERS ARE DOING TERRIBLY. $200M EXTRA IS BEING CUT | 41 | 1h |
| +195 | Investment Banking is Divine | 33 | 39m |
| +192 | Analyst: Why is UBS IB doing worse than peers?, UBS CFO: No Comment | 38 | 1h |
| +191 | How do YOU manage networking requests? | 28 | 1h |
| +191 | Another $115bn Mega deal for these banks. Congrats! | 39 | 47m |
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.
Ut delectus esse fugit quod reprehenderit. Repellat rem autem voluptatibus natus. Et porro aliquam et eum quia ab.
Nisi laudantium recusandae magnam accusamus cupiditate molestiae a. Assumenda quia qui qui et.
Animi quam est iusto doloribus. Qui sunt dicta quia quia maxime hic. Ipsum veniam velit ipsa et voluptatem est molestias ab.
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...