Values in an Index

[nnabijan]

Dear Everyone,

I have the following table in excel:

_________________H______________________
A 0.30 0.35 0.40 0.45 0.50 0.55 0.60
2 0.390 0.433 0.473 0.509 0.543 0.573 0.587
3 0.274 0.309 0.342 0.374 0.406 0.437 0.466
4 0.207 0.235 0.261 0.289 0.318 0.346 0.374
4.5 0.183 0.208 0.232 0.258 0.285 0.311 0.339
5 0.164 0.187 0.209 0.232 0.258 0.287 0.310
6 0.135 0.154 0.172 0.192 0.214 0.236 0.261
7 0.114 0.130 0.145 0.163 0.177 0.202 0.224
8 0.098 0.112 0.126 0.140 0.154 0.175 0.195
9 0.0859 0.0981 0.1106 0.1233 0.1357 0.1543 0.1723
10 0.0763 0.0873 0.0986 0.1096 0.1207 0.1375 0.1540
11 0.0687 0.0786 0.0887 0.0988 0.1088 0.1240 0.1385


if for A = 4, and H is 0.36 how to find the corresponding value in the index (between 0.35 and 0.4)

H = 0.4, and A is 5.7 how to find the corresponding value in the index (between 5 and 6)

and also for combined A 5.3 and H 0.52

regards

[Domski]

Please read the forum rules and change your thread title.

Dom

[Domski]

Thanks. Have a look at the attached.

Dom

[nnabijan]

Thank you for your reply.Could yo uhelp me more please, what if H and A are in between and I want the exact value from the index for a value of H=0.42 between 0.4 and 0.5 and for A =5.2 (5 and 6) I do not want the nearest figure. For each value of A, H is linear and for each value of H, A is power. Thank you for your time.

A.jpgH.jpg

[nnabijan]

H has the range from 0.3 to 0.6 and A has the range from 2 to 11, in the middle are factors correlate with A and H at the same time,

I use the FORECAST function to find any value of A let us say 4.6 but just correspond to certain value of H $C$3

=FORECAST(F15,OFFSET($C$3,MATCH(F15,$B$3:$B$16,1)-1,0,2),OFFSET($B$3,MATCH(F15,$B$3:$B$16,1)-1,0,2))

when I tried to apply it for the H values , it does not work well becasue of the values -1,0,2) , could any one help me please?