Vlookup & match

[BG_9641770]

Hi all 

trying to get a mathcad function that returns an rounded match from a table the example is attached, I could put the figures within a graph and use the interpret function but i want a rounded answer to the next D610.

i.e. for the attached sheet the solution would be 1.7m when the looking for an F of 27kNm in column F610  i.e. not an exact match, therefore selecting the higher value in column D610. i.e. in excel this would be a Vloop/match function. 

Thanks

Ben 

[Fred_Kohlhepp]

[Werner_E · Accepted solution]

Here are my 2 Cents