Hi All,
I am new here but have a reasonable understanding of Excel formulas and some VB / Macro work. I am not an expert by any means and I need help with the following.
Not certian if this would be a VBA / Macro subject or a Formula / Function subject.
I have a table that lists tire spring rates at tested PSI and Camber values from the manufacture.
The table is 4 rows with PSI values for Row headers and 9 columns with Camber degree values for Column headers.
I need to be able to input any Camber value in the range of the column headers including those between listed values and any Tire PSI at all including those between listed values and be able to get an accurate tire spring rate to be displayed as a number to be used in other caluclations.
I have made a pretty eleborate Forecast routine and PSI calculation to achieve my goal but there must be a better way to extract data that is right in front of me in a table.
I have attached my working example but would love a VB Macro to do a lot of this in the background for me or find out there is a better formula stratagy to use. This is not the only table I may have to do this with. In my real workbook many named cells and ranges are used.
Thanks in advance for any help.
Bud
Bookmarks