Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting data in tables, if not given then interpolating
Hi, I'm setting up an excel sheet that needs to reference a table to get
values used in further formulas. I have a formula that finds a value and you need to take that value and find it in a column of data and output a certain value from that same column, but from a different row. I can use the HLOOKUP() but if the value is not exact, I would like to be able to interpolate the table data to get an exact answer based on the linear relationship that interpolating uses. If im finding a value R, then I have a table like this: R: 0 0.1 0.2 0.3 a: 1.0 1.07 1.15 1.23 b: 1.0 0.93 0.89 0.75 So if I come to a result where R=0.15, I would like to get the answer of 1.11, which I interpolated. I have very little experience in any sort of programming, so I appreciate any help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Interpolating data timepoints | Excel Discussion (Misc queries) | |||
Pivot tables lose of data fields when selecting | Charts and Charting in Excel | |||
Interpolating tables | Excel Discussion (Misc queries) | |||
Interpolating missing data | Excel Programming | |||
Line Interpolating from X-Y data set. | Excel Programming |