Excel Formaula

Hi,

I am having a problem in excel,

I have got a worksheet which grades the quality of incoming products. This is identified by the date and the registration number of the vehicle that carries the product.

I have got another worksheet with which holds the date, registration number and route number.

Is there a way that I can link the date and registration number from sheet 1 to the same date and registration number from sheet 2 and assign the corresponding route number to sheet 1. I have attached samples of the worksheets