Complex lookup with two criteria

[rmcp20]

Hi all,

Need some help on a lookup formula that can populate results in a table based on two criteria.

Vlookup is useless, as i need two validations, and i have been trying INDEX & MATCH but without sucess.

I need the results in sheet "Data" - Column F (Laps) to be populated in sheet "Results" - column C and E (each individualy, i can use the same formula for both).

I would need excell to find the car number & Tyre brand and populate the results.

Example: Car 1 (A2) and Hankook (D1) in sheet "Results" being the criteria, i would need excell to populate the value in F3 from sheet "Data" in E1 on the "Results", as these is the one that match both criteria.


Data sheet

Car	Driver	Model	Dry tyre	Wet tyre	Laps
1	John	Pontiac	Goodyear		10
1	John	Pontiac		Hankook	7
3	Roy	Chevy	Hankook		11
4	Joseph	Toyota	Goodyear		13

<tbody>
</tbody>

Results sheet

Car	Goodyear	Laps	Hankook	Laps
1
2
3
4
5

<tbody>
</tbody>

Thanks a lot in advance.
Cheers,
Rui

 

[Aladin Akyurek]

Still a mystery what will appear under Goodyear and Hankook in the output...