cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Want the oppurtunity to discuss enhancements to PTC products? Join a working group! X

Vlookup & match

BG_9641770
11-Garnet

Vlookup & match

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 

1 ACCEPTED SOLUTION

Accepted Solutions

Here are my 2 Cents

Werner_E_1-1637686334478.png

 

 

View solution in original post

2 REPLIES 2

Fred_Kohlhepp_0-1637684483956.png

 

Here are my 2 Cents

Werner_E_1-1637686334478.png

 

 

Top Tags