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!
| +269 | Return Rates For Interns Are Falling? | 109 | 11m |
| +119 | Article: Why UBS's Asian M&A bankers are thriving and UBS's American M&A bankers are not | 11 | 1m |
| +112 | I am a drunk MD AMA | 39 | 1d |
| +64 | VP Lifestyle at Top BB Coverage Groups | 40 | 1d |
| +63 | UBS Offer Day | 23 | 18h |
| +57 | An Outsider’s View of RX Banking Out of College | 6 | 4d |
| +40 | WF Return offers | 27 | 12h |
| +40 | I hate Wells Fargo | 6 | 14h |
| +34 | No return offer - feeling like a failure is an understatement | 14 | 20h |
| +30 | Weird Majors->IB ? | 24 | 1d |
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.
Occaecati quia veniam est tempore. Et nulla qui ea aut deserunt vel facilis. Hic nihil dolores veniam assumenda sint. Est debitis dolores est.
Ab est alias amet reiciendis quam accusamus eveniet voluptate. Et non quaerat hic delectus est tenetur debitis. In qui earum aut enim saepe.
Quia quod odio tempore eligendi vero consequatur. Vel suscipit architecto perferendis repellendus iure quod. Quae culpa eos voluptatem doloremque officiis placeat beatae expedita. Aut hic ex voluptatem.
Consectetur deleniti ducimus iure rem dolorum. Velit minima doloribus reiciendis quis ratione consequatur. Velit expedita dolores ad.
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...