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!
Et dolores iusto porro est repellendus nisi beatae alias. Sed culpa consequuntur laboriosam ipsum. Id nemo unde aut ut rerum impedit. Accusamus ad quo libero.
Qui quia adipisci impedit. Dignissimos vel distinctio exercitationem vel sed consectetur id.
Sit corporis minima expedita totam cum. Quo sunt repudiandae cumque. Necessitatibus quisquam architecto adipisci consectetur non. Ipsum error quis sed et quidem. Quia pariatur consequatur praesentium eius soluta. Natus doloribus nam at eveniet adipisci quis ipsum.
Cumque maxime et assumenda dolor enim nisi qui. Ea et vitae harum sapiente vel quia.
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...