Referencing 2 cells to assign a value

[timmycl_7]

Hi,

I have a excel workbook with two worksheets.

I worksheet holds information assessing the quality of incoming loads based on the registration number of the vehicle and date.

The second worksheet holds the following information. Date, vehicle registration and route number.

I need to be able to take the route number from worksheet 2 based on the date and registration number from worksheet 1 matching the date and registration number in worksheet 2.

I have posted a sample sheet.

Thanks for you help

Regards
Tim

[oldchippy]

Hi,

May be something like this, you could hide the yellow columns?

[StephenR]

In E5, confirm with Ctrl+Shift+Enter:

=INDEX(Sheet2!C2:C4,MATCH(B5&D5,Sheet2!A2:A4&Sheet2!B2:B4,0))

[timmycl_7]

Hi Guys,

Both formula worked, thanks very much really appreciated. I ended up using oldchippy's formula simply because I have more chance of fixing it if something goes wrong!

Regards
Tim