table array query

[mart_mrexcel]

0	10	20	30	40	50	60	70	80	90	100
121.8	124.5	127.2	129.9	132.6	135.3	138	140.7	143.4	146.10	148.8

<tbody>
</tbody>

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...