Hi Everyone,
I'm having a problem that has been plaguing me for some time.
I have a spreadsheet of Years, with the cost associated with each year for each particular entry (row). Each row has a different set of years in each column, but I am looking to return the amount for a specified year in just one column at the end.
Before I confuse you more, maybe the attached spreadsheet will help explain.
Lookup in Array.xlsx
I have manually populated Column L to illustrate what I am trying to do. Does anyone happen to know a formula that can do this?
Happy to answer any questions if I can help clarify.
Thank you.
Bookmarks