Overtime Query

[starmumbai]

Dear All,

Please help!!

Need your assistance with the below problem. I have attached the sample file though my actual file has 5000+ population size.
employees are identified by employee id in both the files

Report Tab -populates the month wise overtime payment to each employees
ID-employee id
Paydate-25th of each month
Overtime-amount

ID

Pay Date

Overtime

Master Tab -I would like to populate each cell with the overtime against pay date and employee id by use of formulas

Employee ID's	01/25/2021	02/25/2021	03/25/2021
1001
1002
1003
1004
1005
1006
1007
1008
1009
1010
1011
1012

Thankyou!

 

[pecoflyer]

Perhaps try a Pivot Table
Be aware your dates are not real dates but text looking like dates.
To make them real dates select the range - Data - Text to columns - Check" delimited" - Next - Next - Check " date" - and set the dropdown to desired format - Finish. If the cell contents are now right aligned, the dates are real dates.
If not you'll have to try with other drop down choice
You might also want to read https://www.excelcampus.com/pivot-tables/table-source-pivot-table/
In the future best to add some manually calculated results, your explanations being rather vague