How to find the maximum value among unique distinct data's and Return adjacent column data respective to the maximum value ?

[Pramodpandit123]

Hello Everyone,
How to find the maximum value among unique distinct datas from Distance column and Return Speed column data respective to the maximum value.
For eg: The maximum value of " North in X Axis" is 7.2 among random datas and the Speed column respective to the maximum i.e 7.2 is 7.3.

As VLOOKUP only uses single criteria but in this situation there is multiple criteria i.e Lookup value of North direction and X Axis. What are the possible solutions that we could achieve this ?

P.S : Link to sample Excel file: Loading Google Sheets

 

[Fluff]

As you don't have any text values, that would seem to be irrelevant.