How to match on both ID and Date from another sheet

Hi there,

I am attempting to separate values for the same ID from different dates.

Basically on the earlier date the delivery failed and was redelivered on a later date.

Obviously this means the details of the delivery are different for each date.

I have tried vlookup but am only able to get the value for the first date as the IDs are the same for the different dates.

I have heard about the MATCH function, but am unsure how to use it especially across different sheets.

Any help would be appreciated

Thanks