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.

Thanks
Ben


