Cross Sheet Formula Needing to return a value looking at a table
I am trying to look at a table of capacity percentages by week # and
by team member.
The table has a list of names down the Left Hand Side and the week number in a row along the top (see picture below).
I need to return a value based on the team member and the week # in a metrics sheet that I that will have the persons name and the week #.
My plan is to create a chart for a dashboard and only want to look and this week and next.
Is this possible?
Thank you in advance.,
Help Article Resources
Check out the Formula Handbook template!