I want to put a given value (Cost) in a given position in an array (years 2017-2023) based on a third cell (Cost Yr).. I know (suspect) that a Index Match combo is the way to go but am struggling to get it to work, and I know it's a simple solution, but can't seem to do it and suspect that perhaps an alternative formula is needed.
Excel Problem.JPG
Bookmarks