tRY:
=A9/1000*INDEX($B$3:$F$5,MATCH(A9+0,MID($A$3:$A$5,2,FIND("-",$A$3:$A$5)-2)+0),MATCH(B9,LEFT($B$2:$F$2,FIND(" ",$B$2:$F$2)-1)+0,0))
Confirmed with CTRL+SHIFT+ENTER instead of just ENTER.. you will see { } brackets appear around the formula.
The formula could be less complex if you change your column and row titles to be just numbers (rows - start numbers, column year numbers)
For instance, if you entered just the numbers 1 - 5 for the years and you entered 2000, 5000, 15000 for the Capital Values, then the formula would be
=A9/1000*INDEX($B$3:$F$5,MATCH(A9,$A$3:$A$5),MATCH(B9,$B$2:$F$2,0))
normally entered.
Bookmarks