Quote Originally Posted by FDibbins View Post
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!