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
Check out the Formula Handbook template!