Hi guys,
I'm a long time lurker and have a problem that I've been struggling with this week.
I work in programme management and assign resources to various projects.
I've attached images below of a test sheet to demonstrate what I'm trying to do. Essentially I would like to have the cells B2:G6 auto-populate with the project that resource is assigned to based on the dates in cells B1:G1. The date range of their assigned project can be found in the second image. So far I have tried an =MEDIAN formula to ascertain that the dates in B1:G1 fall between the dates in tab two. I've also tried to use a very complicated SUMPRODUCT formula which didn't end up working out.
Any help would be very much appreciated!
I'm a long time lurker and have a problem that I've been struggling with this week.
I work in programme management and assign resources to various projects.
I've attached images below of a test sheet to demonstrate what I'm trying to do. Essentially I would like to have the cells B2:G6 auto-populate with the project that resource is assigned to based on the dates in cells B1:G1. The date range of their assigned project can be found in the second image. So far I have tried an =MEDIAN formula to ascertain that the dates in B1:G1 fall between the dates in tab two. I've also tried to use a very complicated SUMPRODUCT formula which didn't end up working out.
Any help would be very much appreciated!