lookup a value in a range

[lansdowne]

I have 2 years racing results and want to calculate a new "poundage" rating using Furs(I2) and Going(G2)from my table.

I have produced the range below.

<colgroup><col style="mso-width-source:userset;mso-width-alt:1462;width:30pt" width="40"> <col style="width:48pt" span="6" width="64"> <col style="width:48pt" span="4" width="64"> </colgroup><tbody>
[TD="width: 40"][/TD]
[TD="class: xl67, width: 64"]HVY[/TD]
[TD="class: xl67, width: 64"]SFT[/TD]
[TD="class: xl67, width: 64"]GS[/TD]
[TD="class: xl67, width: 64"]GD[/TD]
[TD="class: xl67, width: 64"]GF[/TD]
[TD="class: xl68, width: 64"]FM[/TD]
[TD="class: xl67, width: 64"]FS[/TD]
[TD="class: xl67, width: 64"]PT1[/TD]
[TD="class: xl67, width: 64"]PT2[/TD]
[TD="class: xl67, width: 64"]PT3[/TD]

[TD="class: xl64"]5[/TD]
[TD="class: xl65"]2.10
[/TD]
[TD="class: xl66"]2.40[/TD]
[TD="class: xl66"]3.20[/TD]
[TD="class: xl66"]3.50[/TD]
[TD="class: xl66"]3.70[/TD]
[TD="class: xl69"]3.50[/TD]
[TD="class: xl66"]2.80[/TD]
[TD="class: xl66"]3.20[/TD]
[TD="class: xl66"]3.30[/TD]
[TD="class: xl66"]2.80[/TD]

[TD="class: xl64"]6[/TD]
[TD="class: xl65"]2.00[/TD]
[TD="class: xl66"]2.20[/TD]
[TD="class: xl66"]2.70[/TD]
[TD="class: xl66"]3.00[/TD]
[TD="class: xl66"]3.20[/TD]
[TD="class: xl69"]2.70[/TD]
[TD="class: xl66"]2.00[/TD]
[TD="class: xl66"]3.10[/TD]
[TD="class: xl66"]3.20[/TD]
[TD="class: xl66"]2.70[/TD]

[TD="class: xl64"]7[/TD]
[TD="class: xl66"]1.50[/TD]
[TD="class: xl66"]1.80[/TD]
[TD="class: xl66"]2.30[/TD]
[TD="class: xl66"]2.50[/TD]
[TD="class: xl66"]2.60[/TD]
[TD="class: xl69"]2.40[/TD]
[TD="class: xl66"]1.75[/TD]
[TD="class: xl66"]2.50[/TD]
[TD="class: xl66"]2.90[/TD]
[TD="class: xl66"]2.20[/TD]

[TD="class: xl64"]8[/TD]
[TD="class: xl66"]1.10[/TD]
[TD="class: xl66"]1.40[/TD]
[TD="class: xl66"]1.60[/TD]
[TD="class: xl66"]2.00[/TD]
[TD="class: xl66"]2.10[/TD]
[TD="class: xl69"]1.90[/TD]
[TD="class: xl66"]1.30[/TD]
[TD="class: xl66"]1.90[/TD]
[TD="class: xl66"]2.30[/TD]
[TD="class: xl66"]1.80[/TD]

[TD="class: xl64"]9[/TD]
[TD="class: xl66"]1.00[/TD]
[TD="class: xl66"]1.30[/TD]
[TD="class: xl66"]1.50[/TD]
[TD="class: xl66"]1.90[/TD]
[TD="class: xl66"]2.00[/TD]
[TD="class: xl69"]1.75[/TD]
[TD="class: xl66"]1.20[/TD]
[TD="class: xl66"]1.85[/TD]
[TD="class: xl66"]2.25[/TD]
[TD="class: xl66"]1.60[/TD]

[TD="class: xl64"]10[/TD]
[TD="class: xl66"]0.90[/TD]
[TD="class: xl66"]1.20[/TD]
[TD="class: xl66"]1.45[/TD]
[TD="class: xl66"]1.75[/TD]
[TD="class: xl66"]1.90[/TD]
[TD="class: xl69"]1.60[/TD]
[TD="class: xl66"]1.15[/TD]
[TD="class: xl66"]1.75[/TD]
[TD="class: xl66"]2.20[/TD]
[TD="class: xl66"]1.50[/TD]

[TD="class: xl64"]11[/TD]
[TD="class: xl66"]0.80[/TD]
[TD="class: xl66"]1.15[/TD]
[TD="class: xl66"]1.40[/TD]
[TD="class: xl66"]1.65[/TD]
[TD="class: xl66"]1.75[/TD]
[TD="class: xl69"]1.30[/TD]
[TD="class: xl63"]1.1[/TD]
[TD="class: xl63"]1.7[/TD]
[TD="class: xl63"]2.1[/TD]
[TD="class: xl63"]1.4[/TD]

[TD="class: xl64"]12[/TD]
[TD="class: xl66"]0.70[/TD]
[TD="class: xl66"]1.10[/TD]
[TD="class: xl66"]1.30[/TD]
[TD="class: xl66"]1.50[/TD]
[TD="class: xl66"]1.60[/TD]
[TD="class: xl69"]1.40[/TD]
[TD="class: xl63"]0.9[/TD]
[TD="class: xl63"]1.6[/TD]
[TD="class: xl63"]2[/TD]
[TD="class: xl63"]1.35[/TD]

[TD="class: xl64"]13[/TD]
[TD="class: xl66"]0.60[/TD]
[TD="class: xl66"]1.00[/TD]
[TD="class: xl66"]1.20[/TD]
[TD="class: xl66"]1.40[/TD]
[TD="class: xl66"]1.45[/TD]
[TD="class: xl69"]1.30[/TD]
[TD="class: xl63"]0.8[/TD]
[TD="class: xl63"]1.5[/TD]
[TD="class: xl63"]1.8[/TD]
[TD="class: xl63"]1.25[/TD]

[TD="class: xl64"]14[/TD]
[TD="class: xl66"]0.50[/TD]
[TD="class: xl66"]0.90[/TD]
[TD="class: xl66"]1.10[/TD]
[TD="class: xl66"]1.25[/TD]
[TD="class: xl66"]1.30[/TD]
[TD="class: xl69"]1.15[/TD]
[TD="class: xl63"]0.7[/TD]
[TD="class: xl63"]1.4[/TD]
[TD="class: xl63"]1.7[/TD]
[TD="class: xl63"]1.1[/TD]

[TD="class: xl64"]15[/TD]
[TD="class: xl66"]0.45[/TD]
[TD="class: xl66"]0.80[/TD]
[TD="class: xl66"]0.95[/TD]
[TD="class: xl66"]1.10[/TD]
[TD="class: xl66"]1.20[/TD]
[TD="class: xl69"]1.00[/TD]
[TD="class: xl63"]0.55[/TD]
[TD="class: xl63"]1.3[/TD]
[TD="class: xl63"]1.4[/TD]
[TD="class: xl63"]0.9[/TD]

[TD="class: xl64"]16[/TD]
[TD="class: xl66"]0.40[/TD]
[TD="class: xl66"]0.70[/TD]
[TD="class: xl66"]0.80[/TD]
[TD="class: xl66"]1.00[/TD]
[TD="class: xl66"]1.10[/TD]
[TD="class: xl69"]0.80[/TD]
[TD="class: xl63"]0.4[/TD]
[TD="class: xl63"]1.1[/TD]
[TD="class: xl63"]1.2[/TD]
[TD="class: xl63"]0.7[/TD]

</tbody>

is it possible to use the distance Furs in F2(Not exact match), and the going in G2 to find the resulting poundage for the appropiate going in the table, to appear in a new cell?

Many Thanks

Davey H