How to change the source of a cell by changing the value of another cell

Originally Posted by FDibbins

in B10, copied down, try this...

=INDEX($E$8:$I$13,ROW(A1)+2,MATCH($B$4,$E$8:$I$8,0))

Note, if you add/subtract any rows between 8 and 10, adjust the row(A1)+2 accordingly

Thank you dear, I was trying to asleep when it just hit me! I just needed to use the MAX function because the numbers are increasing each month and I what i wanted is to bring the last month value into the cell. WOW. I'm so in shock right now!