table array query

[mart_mrexcel]

[TABLE="class: grid, width: 100, align: center"]
<tbody>[TR]
[TD]0[/TD]
[TD]10[/TD]
[TD]20[/TD]
[TD]30[/TD]
[TD]40[/TD]
[TD]50[/TD]
[TD]60[/TD]
[TD]70[/TD]
[TD]80[/TD]
[TD]90[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]121.8[/TD]
[TD]124.5[/TD]
[TD]127.2[/TD]
[TD]129.9[/TD]
[TD]132.6[/TD]
[TD]135.3[/TD]
[TD]138[/TD]
[TD]140.7[/TD]
[TD]143.4[/TD]
[TD]146.10[/TD]
[TD]148.8[/TD]
[/TR]
</tbody>[/TABLE]

Given the table above where in the first row is Weighted while the 2nd row is a target value. If i have an actual value of 132.6 the result (as per the first row is 40), My question is, if i have an actual value of 132, what formula could i use to get the result of 37.5. Thanks

 

[steve the fish]

Try this:

=FORECAST(A4,A1:K1,A2:K2)

With the table in A1:K2 and your value in A4. I make it 37.78 though.

 

[mart_mrexcel]

Thanks Mr. Steve...that helps a lot...