Return Value from Entered Date

[XfortunaX]

I am stuck on the final formula for a vacation workbook.

I am trying to return the value in column C by referencing the date in column B and placing it next to the correct date on the Sheet listed in column A.

The sheet "Dummy, Taylor".
The 8 entered on 02/10/2015 from above would be on row 16 because it falls between 02/01/2015 and 02/15/15 under vacation hours.
The 24 entered on 05/10/2015 from above would be on row 22 because it falls between 05/01/2015 and 05/15/15 under vacation hours.

I have tried to bend this to fit my needs, but have not been successful:
Formula for matching a date within a date range in excel | Get Digital Help - Microsoft Excel resource

Thank you for any help you can pride,

Tuna

 

[CastroTheCat]

Quick and dirty solution:

On the first sheet, maybe in column G, add a formula to find the pay period the leave started in. G2 would look like:

=VLOOKUP(b2,$H$2:$H$500,1,1)

Drag this down column G as far as you want your records to go. For the formula below, pretend you have 500 leave records.

On your second sheet, use a SUMIF to add up the hours of each type of leave. Cell F14 would look like:

=SUMIF('First Sheet'!$G$2:$G$500,B14,'First Sheet'!C$2:C$500)

Drag this across cells F14-H14 (the reference to column C should shift right for each column as you do it), then drag down.

Hope this helps.





"I'm not a genius. I'm a chicken".
Pinky Pie

 

[XfortunaX]

Thank you CatroTheCat! Appreciate the response. Yes, this is quick and dirty but works for the time being.