This is a modification of an old worksheet where I would use HLOOKUP to look in the table (shown as old table) and based on the value in column B of the worksheet, I would find the data below and above it and then use interpolation to fill in the value in column C. The column of the old table that was selected was determined by the value in D5. For example, if D5 is 1.8, HLOOKUP function was used along with the value 25 in B8 to select data1 and data2 under the "1.8" column in the old table. Then I would interpolate between data1 and data2 and this result was placed in C8.
However now I have gotten equations that have replaced the data in the table. I was still going to use the HLOOKUP function to select the equations from "new table" based on the value in D5, but I can't figure out how to do this since you can't enter a function as f(x) = 3125 * power (x,-1.45) and then have C8 contain this function evaluated using B8 for x. I am have searched on ways to do this but I can't even find a good way to describe what I want to do so I get lots of irrelevant responses.
I am open to ditching the table and having a drop down menu for D5 and depending on what I select having the correct formula filled in for column C, but I am running in to issues with that method as well. Thanks for any help...BTW, I am using Excel 2007.
Bookmarks