Looking to return a value given a specific row and column

I would like update a goal target automatically based on today's date from a matrix. Through "=Today" , I have established the current year and current month. From there I want to populate the yellow cell in the "Current Goal" column for either "Annual" or "Cumulative". This cell will then be cross-linked to a metrics sheet containing actual performance and then set forth in a graphical form in a dashboard report.

Looking for some help on this...through a conditional formula, or filtering or ???


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!