MAX IF INDEX Function?

Currently, I have a table like the one below.

               Jan-16   Feb-16  Mar-16  Apr-16  May-16  Jun-16  Jul-16  Aug-16  Sep-16  Oct-16  Nov-16  Dec-16
Forecast       5        8       7       -       -       -       -       -       -       -       -       -

The monthly forecast figure is set to populate only once that month closes.

In my dashboard, I am attempting to capture the most recent Forecast number in this table so the output would look something like...

Current Forecast    7

I would assume that to achieve this, Current Forecast would require a series of IF, INDEX, MATCH, and MAX (for max date) functions but I'm unable to figure this out. Any thoughts?