View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave_AD
 
Posts: n/a
Default Interpolation with VLOOKUP

I'm trying to construct a workbook with the ability to interpolate between 2
values.
If we consider two columns of data, for example:

A B
100 97
110 120
135 135
157 166

What function or nested functions will return an "A" value if I input a "B"
value of 147 ?
--
Dave_DD