I have 12 tabs for each month of the year. I'm trying to return a name that is listed in a cell tied to a date range on my summary page. See below. I know that the reason this formula isn't working is because a name isn't a value but i'm not sure what formula would work?
Each tab is similar as below.
My formula should return Esteban Mendoz in column K of my summary because it matches to the week number.
Each tab is similar as below.
My formula should return Esteban Mendoz in column K of my summary because it matches to the week number.