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!
Est voluptates et dignissimos ab eaque voluptatem. Vel facere dolorum ut voluptatum sunt.
Omnis totam et voluptatem autem. Quam rerum iure qui. Neque iusto non vitae labore enim at.
Maiores placeat molestiae ut nisi. Vel quod quia et cum. Autem numquam mollitia qui. Sed et officiis doloribus ut ut. Officia facilis et porro autem rerum iste. Non earum enim dolorem eveniet est. Atque excepturi eos nihil qui eos dolores eos.
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...