Skip to main content
12-Amethyst
November 23, 2021
Solved

Vlookup & match

  • November 23, 2021
  • 2 replies
  • 1743 views

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. 

 

BG_9641770_0-1637682252511.png

 

Thanks

Ben 

Best answer by Werner_E

Here are my 2 Cents

Werner_E_1-1637686334478.png

 

 

2 replies

23-Emerald I
November 23, 2021
Werner_E25-Diamond IAnswer
25-Diamond I
November 23, 2021

Here are my 2 Cents

Werner_E_1-1637686334478.png