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

Hi!

Depends on what result you're after:

If you think the result shoud be 135:

D1 = 147

=INDEX(A1:A4,MATCH(D1,B1:B4))

If you think the result should be 157:

The table would need to be sorted in descending order

=INDEX(A1:A4,MATCH(D1,B1:B4,-1))

Biff

"Dave_AD" wrote in message
...
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