Look up between dates

[shellhutchings]

Hi, I have a spreadsheet that on row one, holds an employee name (a), hours worked such as 40 per week (b) and the dates employee worked 40hrs ie 27/06/20 - 01/09/20 (c & d). However the name is repeated several times due to the different hours so row 2 could be 25 hrs per week for 02/09/20 - 15/12/21 and so on. My second spreadsheet holds columns a and b as with the first spreadsheet but on this, column c is a specific date such as 03/09/21. Is there a way to pull through the specific hrs that the date applies to? I know a vlook up will only pull the first line but in this instance, I'd need the row 2 25 hrs to pull through.

 

[shellhutchings]

Hi, I have a spreadsheet that on row one, holds an employee name (a), hours worked such as 40 per week (b) and the dates employee worked 40hrs ie 27/06/20 - 01/09/20 (c & d). However the name is repeated several times due to the different hours so row 2 could be 25 hrs per week for 02/09/20 - 15/12/21 and so on. My second spreadsheet holds columns a and b as with the first spreadsheet but on this, column c is a specific date such as 03/09/21. Is there a way to pull through the specific hrs that the date applies to? I know a vlook up will only pull the first line but in this instance, I'd need the row 2 25 hrs to pull through.

Sorry i mean that the second sheet has column A name then a specific date.