Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Interpolation within a data table
I will try to explain this the best I can.
I have to do a calcualtion. The answer to that calculation will then be used to look up data in a table. For Example A B C D 6.60 13657 178.3 70.20 67.79 6.70 13886 179.9 70.16 67.68 My calculated answer was 6.67. How do I write a formula so that excel will return the corresponding values for A B C & D for 6.67. I have tried but the VLOOKUP function but it keeps returning the lower values which is not what I want. Yours hopefully Simon |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to do linear interpolation between entries in lookup table | Excel Discussion (Misc queries) | |||
Find a Value by interpolation from a table of x and y values | Excel Worksheet Functions | |||
Interpolate, Interpolation, VlookUp, HlookUp, Read a table | Excel Worksheet Functions | |||
help with interpolation and limit of interpolation | Excel Discussion (Misc queries) | |||
interpolation XY data with bezier curver | Charts and Charting in Excel |