With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Friday, May 11, 2018
yogi_From 'Speed Torque Table' Sheet2 Find The Torque Associated With Specified Speed Value In Cell A3
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
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