Looking Up Date Period Based on Date Ranges

[amac3434]

Feeling silly I cannot figure this out - since it appears pretty straight forward. That being said, I'm not above asking for help


I've uploaded the spreadsheet at:

https://docs.google.com/open?id=0B5W2MSEwwac5aEhYd1ZBSDJVQTQ


I am looking for the appropriate formula to calculate the "Period" that a date entered in Column A (Prof Serv tab) based on the table found on the Period Dates tab.


Any clues are appreciated!

 

[Faseeh]

Hi amac3434,


Welcome to the forums and you can try following in B3 in professional services sheet:

=SUMPRODUCT((A4>='Period Dates'!$B$3:$B$15)*('Professional Services'!A4<='Period Dates'!$C$3:$C$15)*('Period Dates'!$A$3:$A$15))

..and drag down, hope that helps...


Regards,

 

[amac3434]

That did it - Thanks so much Faseeh.

 

[Kevin@Radstock]

Hi


INDEX & MATCH!

=INDEX('Period Dates'!$A$3:$A$15,MATCH(A3,'Period Dates'!$B$3:$B$15,1))