Looking to return a value given a specific row and column

Mike Ferringer

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 ???

Mike Ferringer

Ignore this post. Found another way to accomplish by restructuring the sheet and utilizing "Index/Collect" function.