Here is what I have:
Sheet1
A3:A250 is a list of names.
In Column C I want to return values based on their names, but also on the date (text month) listed in C1. The values are on Sheet2. The values in C1 will change each month, so it won't ever be looking at the same column on sheet2 for the value, since it is based on a moving month.
Sheet2:
Names are in column A (A2:A250).
The values I want to return are listed horizontally for the people listed from columns B:M (so, B2:M250 would be the whole table). And the month in which I want to return a value for is listed in row 1, so B1:M1.
I'm assuming this needs an Index,Match type formula but can't seem to remember how to do it based on both the person's name as well as match it to the month in row 1.
Bookmarks