How to use Index and Match with multiple criteria?

Hello! I have searched online and followed some tutorials for these functions, I can see how they work but I just can't adapt it to my spreadsheet.

I have data on two sheets, I need the first sheet to read the second sheets data and bring just one match onto the first sheet. Please check my attached file to see how it's set up.

On sheet 2 I keep a list of every driver in a race and the time they posted, on the first sheet I keep a summary by each race. I have given each race an ID number to separate them. But then I need to search by position and return the driver in first position.

So Sheet1 A2, needs to search Sheet2 for the same ID, then find position 1 in column D, then return the driver name in column E.

I am really confused on this. Currently I'm using VLOOKUP which works, however I need to filter data around in Sheet2 a lot so I don't feel comfortable with a dynamic formula that just brings back the first result it finds. I would like to implement something definite that always looks for position 1.

Thank you in advance for any help!

I created a key which bundles all criteria together and then use the match/index combo

Maybe like this? Array FOrmula

=INDEX(Drivers!$E$2:$E$11,MATCH(1,(A2=Drivers!$A$2:$A$11)*(B2=Drivers!$B$2:$B$6)*(C2=Drivers!$C$2:$C$6),0))

Azumi

See attached file.

Thank you all for your responses.I didn't want to add any more data because my actual sheet is 20,000 rows plus, so adding keys will be sloppy. But thank you.

The other two were a bit baffling at first, but I eventually realised I had to extend all the ranges not just column E! Thank you so much, I ended up confusing myself with the tutorials I had read.