Google Spreadsheet Post #2445
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI May-11-2018
question by: Tyler Toepke-Floyd
https://productforums.google.com/forum/#!topic/docs/2LCjOMYaI6w;context-place=forum/docs
How to get sheets to pick a value from a table that is closest to a target value in Sheets
I have a table that contains testing data values for speed and torque of a motor. I am doing a calculation to give me a calculated speed. I want to make a formula that will find the speed closest to my target value, and then grab the torque that is associated with that speed. The goal is to find the actual attainable torque based on a theoretical speed.
Target speed 1000 RPM
table in separate sheet
Speed Torque
980 21
997 19
1005 18
1012 16
I would want the cell to display 19 as the answer given the input of 1000.
So its looking up a value closest to the target value and then grabbing the number from the cell beside it. Hope this makes sense
No comments:
Post a Comment