Index/match/vlookup

[kagma]

exs.jpeg

Hi people, thanks ahead for the comments and reads.

The problem that I've is that I have two different reports of times, on the first the data is displayed with the ID of the employee, the date of the over time done, the amount of that over time, and a date of system check of the data. On the second report is displayed the ID of the employee, the date of the over time done and the charge that that amount of over time is payed.

I need to make a report where is shown the id of the employee, the date of the over time, the amount of the over time (this is all on the first report) and the charge of the over time (displayed on the second report).

The problem that I have is produced because the register of the over time isn't the same as the register of the charge of overtime. This produced duplicated data to search, beacause in one month, one employee can do several over time days, but no necesarlly register a different tipe of charge (displayed on the second report).

So, I need a way through INDEX/MATCH to associated the charge of the overtime with the especific date and employee code.

Sorry for my english, isn't very good.

[ChemistB]

Hard to tell from a picture (to upload an example spreadsheet Go Advanced>Manage Attachments)

Sounds like you need SUMIFS

= SUMIFS(charge column, date column, date expected, ID column, ID Expected)