Getting data from table with three variables

rajeshasv · Mar 23, 2014

[table="width: 462"]
<tbody>[tr]
[td="width: 102, bgcolor: Transparent"][/td]
[td="width: 102, bgcolor: Transparent"][/td]
[td="width: 102, bgcolor: Transparent"][/td]
[td="width: 102, bgcolor: Transparent"][/td]
[td="width: 102, bgcolor: Transparent"][/td]
[td="width: 102, bgcolor: Transparent"][/td]
[/tr]
[tr]
[td="bgcolor: Transparent"][/td]
[td="class: Xl76, bgcolor: White"]sounding/trim
[/td]
[td="class: Xl77, bgcolor: #ffff99"][/td]
[td="class: Xl74, bgcolor: #ffff99"]1.00
[/td]
[td="class: Xl77, bgcolor: #ffff99"]2
[/td]
[td="bgcolor: Transparent"][/td]
[/tr]
[tr]
[td="bgcolor: Transparent"][/td]
[td="class: Xl66, bgcolor: #ffff99"]1
[/td]
[td="class: Xl77, bgcolor: #ffff99"][/td]
[td="class: Xl66, bgcolor: #ffff99"][/td]
[td="class: Xl66, bgcolor: #ffff99"][/td]
[td="bgcolor: Transparent"][/td]
[/tr]
[tr]
[td="bgcolor: Transparent"][/td]
[td="class: Xl67, bgcolor: #92d050"]2
[/td]
[td="class: Xl68, bgcolor: #92d050"][/td]
[td="class: Xl73, bgcolor: #92d050"][/td]
[td="class: Xl69, bgcolor: #92d050"][/td]
[td="bgcolor: Transparent"][/td]
[/tr]
[tr]
[td="bgcolor: Transparent"][/td]
[td="class: Xl70, bgcolor: #92d050"]3
[/td]
[td="class: Xl67, bgcolor: #92d050"][/td]
[td="class: Xl65, bgcolor: #92d050"][/td]
[td="class: Xl67, bgcolor: #92d050"][/td]
[td="bgcolor: Transparent"][/td]
[/tr]
[tr]
[td="bgcolor: Transparent"][/td]
[td="class: Xl71, bgcolor: #92d050"][/td]
[td="class: Xl68, bgcolor: #92d050"][/td]
[td="class: Xl65, bgcolor: #92d050"][/td]
[td="class: Xl68, bgcolor: #92d050"][/td]
[td="bgcolor: Transparent"][/td]
[/tr]
[tr]
[td="bgcolor: Transparent"]

[/td]
[td="class: Xl72, bgcolor: #92d050"][/td]
[td="class: Xl68, bgcolor: #92d050"][/td]
[td="class: Xl75, bgcolor: #92d050"]0.00
[/td]
[td="class: Xl68, bgcolor: #92d050"][/td]
[td="bgcolor: Transparent"][/td]
[/tr]
</tbody>[/table]

i want to get data for following table for list 1

from following table
[table="width: 770"]
<tbody>[tr]
[td="class: Xl65, width: 102, bgcolor: Transparent"]sounding
[/td]
[td="class: Xl65, width: 102, bgcolor: Transparent"]heel/trim
[/td]
[td="class: Xl66, width: 102, bgcolor: Transparent, align: Right"]-1.0
[/td]
[td="class: Xl65, width: 102, bgcolor: Transparent, align: Right"][/td]
[td="class: Xl65, width: 102, bgcolor: Transparent, align: Right"]1
[/td]
[td="class: Xl65, width: 102, bgcolor: Transparent, align: Right"]2
[/td]
[td="class: Xl65, width: 102, bgcolor: Transparent, align: Right"]3
[/td]
[td="class: Xl65, width: 102, bgcolor: Transparent, align: Right"]4
[/td]
[td="class: Xl65, width: 102, bgcolor: Transparent, align: Right"]5
[/td]
[td="class: Xl65, width: 102, bgcolor: Transparent, align: Right"]6
[/td]
[/tr]
[tr]
[td="class: Xl65, bgcolor: Transparent, align: Right"]0.5
[/td]
[td="class: Xl65, bgcolor: Transparent, align: Right"]3
[/td]
[td="class: Xl67, bgcolor: Transparent"]4
[/td]
[td="class: Xl67, bgcolor: Transparent"]5.2
[/td]
[td="class: Xl67, bgcolor: Transparent"]6.5
[/td]
[td="class: Xl67, bgcolor: Transparent"]7.8
[/td]
[td="class: Xl67, bgcolor: Transparent"]9.1
[/td]
[td="class: Xl67, bgcolor: Transparent"]10.5
[/td]
[td="class: Xl67, bgcolor: Transparent"]11.9
[/td]
[td="class: Xl67, bgcolor: Transparent"]13.1
[/td]
[/tr]
[tr]
[td="class: Xl65, bgcolor: Transparent, align: Right"]0.5
[/td]
[td="class: Xl65, bgcolor: Transparent, align: Right"]2
[/td]
[td="class: Xl67, bgcolor: Transparent"]2.2
[/td]
[td="class: Xl67, bgcolor: Transparent"]3.4
[/td]
[td="class: Xl67, bgcolor: Transparent"]4.6
[/td]
[td="class: Xl67, bgcolor: Transparent"]5.9
[/td]
[td="class: Xl67, bgcolor: Transparent"]7.1
[/td]
[td="class: Xl67, bgcolor: Transparent"]8.5
[/td]
[td="class: Xl67, bgcolor: Transparent"]9.8
[/td]
[td="class: Xl67, bgcolor: Transparent"]11.1
[/td]
[/tr]
[tr]
[td="class: Xl65, bgcolor: Transparent, align: Right"]0.5
[/td]
[td="class: Xl65, bgcolor: Transparent, align: Right"]1
[/td]
[td="class: Xl67, bgcolor: Transparent"]0.5
[/td]
[td="class: Xl67, bgcolor: Transparent"]1.6
[/td]
[td="class: Xl67, bgcolor: Transparent"]2.8
[/td]
[td="class: Xl67, bgcolor: Transparent"]4
[/td]
[td="class: Xl67, bgcolor: Transparent"]5.3
[/td]
[td="class: Xl67, bgcolor: Transparent"]6.6
[/td]
[td="class: Xl67, bgcolor: Transparent"]7.8
[/td]
[td="class: Xl67, bgcolor: Transparent"]9.2
[/td]
[/tr]
[tr]
[td="class: Xl65, bgcolor: Transparent, align: Right"]0.5
[/td]
[td="class: Xl65, bgcolor: Transparent, align: Right"]0.5
[/td]
[td="class: Xl67, bgcolor: Transparent"]-0.4
[/td]
[td="class: Xl67, bgcolor: Transparent"]0.8
[/td]
[td="class: Xl67, bgcolor: Transparent"]2
[/td]
[td="class: Xl67, bgcolor: Transparent"]3.2
[/td]
[td="class: Xl67, bgcolor: Transparent"]4.4
[/td]
[td="class: Xl67, bgcolor: Transparent"]5.7
[/td]
[td="class: Xl67, bgcolor: Transparent"]6.9
[/td]
[td="class: Xl67, bgcolor: Transparent"]8.2
[/td]
[/tr]
[tr]
[td="class: Xl65, bgcolor: Transparent, align: Right"]0.5
[/td]
[td="class: Xl65, bgcolor: Transparent, align: Right"][/td]
[td="class: Xl67, bgcolor: Transparent"]-1.1
[/td]
[td="class: Xl67, bgcolor: Transparent"][/td]
[td="class: Xl67, bgcolor: Transparent"]1.2
[/td]
[td="class: Xl67, bgcolor: Transparent"]2.3
[/td]
[td="class: Xl67, bgcolor: Transparent"]3.5
[/td]
[td="class: Xl67, bgcolor: Transparent"]4.8
[/td]
[td="class: Xl67, bgcolor: Transparent"]6
[/td]
[td="class: Xl67, bgcolor: Transparent"]7.3
[/td]
[/tr]
[tr]
[td="class: Xl65, bgcolor: Transparent, align: Right"]0.5
[/td]
[td="class: Xl65, bgcolor: Transparent, align: Right"]-0.5
[/td]
[td="class: Xl67, bgcolor: Transparent"]-1.9
[/td]
[td="class: Xl67, bgcolor: Transparent"]-0.8
[/td]
[td="class: Xl67, bgcolor: Transparent"]0.4
[/td]
[td="class: Xl67, bgcolor: Transparent"]1.5
[/td]
[td="class: Xl67, bgcolor: Transparent"]2.7
[/td]
[td="class: Xl67, bgcolor: Transparent"]3.9
[/td]
[td="class: Xl67, bgcolor: Transparent"]5.2
[/td]
[td="class: Xl67, bgcolor: Transparent"]6.4
[/td]
[/tr]
[tr]
[td="class: Xl65, bgcolor: Transparent, align: Right"]0.5
[/td]
[td="class: Xl65, bgcolor: Transparent, align: Right"]-1
[/td]
[td="class: Xl67, bgcolor: Transparent"]-2.6
[/td]
[td="class: Xl67, bgcolor: Transparent"]-1.5
[/td]
[td="class: Xl67, bgcolor: Transparent"]-0.4
[/td]
[td="class: Xl67, bgcolor: Transparent"]0.8
[/td]
[td="class: Xl67, bgcolor: Transparent"]1.9
[/td]
[td="class: Xl67, bgcolor: Transparent"]3.1
[/td]
[td="class: Xl67, bgcolor: Transparent"]4.3
[/td]
[td="class: Xl67, bgcolor: Transparent"]5.6
[/td]
[/tr]
[tr]
[td="class: Xl65, bgcolor: Transparent, align: Right"]0.5
[/td]
[td="class: Xl65, bgcolor: Transparent, align: Right"]-2
[/td]
[td="class: Xl67, bgcolor: Transparent"]-4
[/td]
[td="class: Xl67, bgcolor: Transparent"]-2.9
[/td]
[td="class: Xl67, bgcolor: Transparent"]-1.8
[/td]
[td="class: Xl67, bgcolor: Transparent"]-0.7
[/td]
[td="class: Xl67, bgcolor: Transparent"]0.4
[/td]
[td="class: Xl67, bgcolor: Transparent"]1.6
[/td]
[td="class: Xl67, bgcolor: Transparent"]2.8
[/td]
[td="class: Xl67, bgcolor: Transparent"]4
[/td]
[/tr]
[tr]
[td="class: Xl65, bgcolor: Transparent, align: Right"]0.5
[/td]
[td="class: Xl65, bgcolor: Transparent, align: Right"]-3
[/td]
[td="class: Xl67, bgcolor: Transparent"]-5.3
[/td]
[td="class: Xl67, bgcolor: Transparent"]-4.2
[/td]
[td="class: Xl67, bgcolor: Transparent"]-3.2
[/td]
[td="class: Xl67, bgcolor: Transparent"]-2.1
[/td]
[td="class: Xl67, bgcolor: Transparent"]-1
[/td]
[td="class: Xl67, bgcolor: Transparent"]0.1
[/td]
[td="class: Xl67, bgcolor: Transparent"]1.3
[/td]
[td="class: Xl67, bgcolor: Transparent"]2.5
[/td]
[/tr]
[tr]
[td="class: Xl65, bgcolor: Transparent"][/td]
[td="class: Xl65, bgcolor: Transparent"][/td]
[td="class: Xl67, bgcolor: Transparent"][/td]
[td="class: Xl67, bgcolor: Transparent"][/td]
[td="class: Xl67, bgcolor: Transparent"][/td]
[td="class: Xl67, bgcolor: Transparent"][/td]
[td="class: Xl67, bgcolor: Transparent"][/td]
[td="class: Xl67, bgcolor: Transparent"][/td]
[td="class: Xl67, bgcolor: Transparent"][/td]
[td="class: Xl65, bgcolor: Transparent"][/td]
[/tr]
[tr]
[td="class: Xl65, bgcolor: Transparent, align: Right"]1
[/td]
[td="class: Xl65, bgcolor: Transparent, align: Right"]3
[/td]
[td="class: Xl67, bgcolor: Transparent"]5.7
[/td]
[td="class: Xl67, bgcolor: Transparent"]6.9
[/td]
[td="class: Xl67, bgcolor: Transparent"]8.1
[/td]
[td="class: Xl67, bgcolor: Transparent"]9.3
[/td]
[td="class: Xl67, bgcolor: Transparent"]10.5
[/td]
[td="class: Xl67, bgcolor: Transparent"]11.7
[/td]
[td="class: Xl67, bgcolor: Transparent"]12.9
[/td]
[td="class: Xl67, bgcolor: Transparent"]14.2
[/td]
[/tr]
[tr]
[td="class: Xl65, bgcolor: Transparent, align: Right"]1
[/td]
[td="class: Xl65, bgcolor: Transparent, align: Right"]2
[/td]
[td="class: Xl67, bgcolor: Transparent"]3.3
[/td]
[td="class: Xl67, bgcolor: Transparent"]4.5
[/td]
[td="class: Xl67, bgcolor: Transparent"]5.6
[/td]
[td="class: Xl67, bgcolor: Transparent"]6.8
[/td]
[td="class: Xl67, bgcolor: Transparent"]8
[/td]
[td="class: Xl67, bgcolor: Transparent"]9.2
[/td]
[td="class: Xl67, bgcolor: Transparent"]10.4
[/td]
[td="class: Xl67, bgcolor: Transparent"]11.6
[/td]
[/tr]
[tr]
[td="class: Xl65, bgcolor: Transparent, align: Right"]1
[/td]
[td="class: Xl65, bgcolor: Transparent, align: Right"]1
[/td]
[td="class: Xl67, bgcolor: Transparent"]1.1
[/td]
[td="class: Xl67, bgcolor: Transparent"]2.2
[/td]
[td="class: Xl67, bgcolor: Transparent"]3.3
[/td]
[td="class: Xl67, bgcolor: Transparent"]4.4
[/td]
[td="class: Xl67, bgcolor: Transparent"]5.6
[/td]
[td="class: Xl67, bgcolor: Transparent"]6.8
[/td]
[td="class: Xl67, bgcolor: Transparent"]7.9
[/td]
[td="class: Xl67, bgcolor: Transparent"]9.1
[/td]
[/tr]
[tr]
[td="class: Xl65, bgcolor: Transparent, align: Right"]1
[/td]
[td="class: Xl65, bgcolor: Transparent, align: Right"]0.5
[/td]
[td="class: Xl67, bgcolor: Transparent"][/td]
[td="class: Xl67, bgcolor: Transparent"]1.1
[/td]
[td="class: Xl67, bgcolor: Transparent"]2.2
[/td]
[td="class: Xl67, bgcolor: Transparent"]3.3
[/td]
[td="class: Xl67, bgcolor: Transparent"]4.5
[/td]
[td="class: Xl67, bgcolor: Transparent"]5.6
[/td]
[td="class: Xl67, bgcolor: Transparent"]6.8
[/td]
[td="class: Xl67, bgcolor: Transparent"]8
[/td]
[/tr]
[tr]
[td="class: Xl65, bgcolor: Transparent, align: Right"]1
[/td]
[td="class: Xl65, bgcolor: Transparent, align: Right"][/td]
[td="class: Xl67, bgcolor: Transparent"]-1.3
[/td]
[td="class: Xl67, bgcolor: Transparent"][/td]
[td="class: Xl67, bgcolor: Transparent"]1.1
[/td]
[td="class: Xl67, bgcolor: Transparent"]2.2
[/td]
[td="class: Xl67, bgcolor: Transparent"]3.3
[/td]
[td="class: Xl67, bgcolor: Transparent"]4.5
[/td]
[td="class: Xl67, bgcolor: Transparent"]5.6
[/td]
[td="class: Xl67, bgcolor: Transparent"]6.8
[/td]
[/tr]
[tr]
[td="class: Xl65, bgcolor: Transparent, align: Right"]1
[/td]
[td="class: Xl65, bgcolor: Transparent, align: Right"]-0.5
[/td]
[td="class: Xl67, bgcolor: Transparent"]-2.5
[/td]
[td="class: Xl67, bgcolor: Transparent"]-1.2
[/td]
[td="class: Xl67, bgcolor: Transparent"][/td]
[td="class: Xl67, bgcolor: Transparent"]1.2
[/td]
[td="class: Xl67, bgcolor: Transparent"]2.3
[/td]
[td="class: Xl67, bgcolor: Transparent"]3.4
[/td]
[td="class: Xl67, bgcolor: Transparent"]4.5
[/td]
[td="class: Xl67, bgcolor: Transparent"]5.7
[/td]
[/tr]
[tr]
[td="class: Xl65, bgcolor: Transparent, align: Right"]1
[/td]
[td="class: Xl65, bgcolor: Transparent, align: Right"]-1
[/td]
[td="class: Xl67, bgcolor: Transparent"]-3.7
[/td]
[td="class: Xl67, bgcolor: Transparent"]-2.4
[/td]
[td="class: Xl67, bgcolor: Transparent"]-1.1
[/td]
[td="class: Xl67, bgcolor: Transparent"]0.1
[/td]
[td="class: Xl67, bgcolor: Transparent"]1.2
[/td]
[td="class: Xl67, bgcolor: Transparent"]2.3
[/td]
[td="class: Xl67, bgcolor: Transparent"]3.4
[/td]
[td="class: Xl67, bgcolor: Transparent"]4.6
[/td]
[/tr]
[tr]
[td="class: Xl65, bgcolor: Transparent, align: Right"]1
[/td]
[td="class: Xl65, bgcolor: Transparent, align: Right"]-2
[/td]
[td="class: Xl67, bgcolor: Transparent"]-5.9
[/td]
[td="class: Xl67, bgcolor: Transparent"]-4.7
[/td]
[td="class: Xl67, bgcolor: Transparent"]-3.5
[/td]
[td="class: Xl67, bgcolor: Transparent"]-2.2
[/td]
[td="class: Xl67, bgcolor: Transparent"]-0.9
[/td]
[td="class: Xl67, bgcolor: Transparent"]0.3
[/td]
[td="class: Xl67, bgcolor: Transparent"]1.4
[/td]
[td="class: Xl67, bgcolor: Transparent"]2.5
[/td]
[/tr]
[tr]
[td="class: Xl65, bgcolor: Transparent, align: Right"]1
[/td]
[td="class: Xl65, bgcolor: Transparent, align: Right"]-3
[/td]
[td="class: Xl67, bgcolor: Transparent"]-8.1
[/td]
[td="class: Xl67, bgcolor: Transparent"]-6.9
[/td]
[td="class: Xl67, bgcolor: Transparent"]-5.7
[/td]
[td="class: Xl67, bgcolor: Transparent"]-4.5
[/td]
[td="class: Xl67, bgcolor: Transparent"]-3.2
[/td]
[td="class: Xl67, bgcolor: Transparent"]-2
[/td]
[td="class: Xl67, bgcolor: Transparent"]-0.7
[/td]
[td="class: Xl67, bgcolor: Transparent"]0.5
[/td]
[/tr]
[tr]
[td="class: Xl65, bgcolor: Transparent"][/td]
[td="class: Xl65, bgcolor: Transparent"][/td]
[td="class: Xl67, bgcolor: Transparent"][/td]
[td="class: Xl67, bgcolor: Transparent"][/td]
[td="class: Xl67, bgcolor: Transparent"][/td]
[td="class: Xl67, bgcolor: Transparent"][/td]
[td="class: Xl67, bgcolor: Transparent"][/td]
[td="class: Xl67, bgcolor: Transparent"][/td]
[td="class: Xl67, bgcolor: Transparent"][/td]
[td="class: Xl65, bgcolor: Transparent"][/td]
[/tr]
[tr]
[td="class: Xl65, bgcolor: Transparent, align: Right"]1.5
[/td]
[td="class: Xl65, bgcolor: Transparent, align: Right"]3
[/td]
[td="class: Xl67, bgcolor: Transparent"]7.7
[/td]
[td="class: Xl67, bgcolor: Transparent"]9
[/td]
[td="class: Xl67, bgcolor: Transparent"]10.2
[/td]
[td="class: Xl67, bgcolor: Transparent"]11.4
[/td]
[td="class: Xl68, bgcolor: Transparent"]12.6
[/td]
[td="class: Xl67, bgcolor: Transparent"]13.8
[/td]
[td="class: Xl67, bgcolor: Transparent"]15.1
[/td]
[td="class: Xl67, bgcolor: Transparent"]16.3
[/td]
[/tr]
[tr]
[td="class: Xl65, bgcolor: Transparent, align: Right"]1.5
[/td]
[td="class: Xl65, bgcolor: Transparent, align: Right"]2
[/td]
[td="class: Xl67, bgcolor: Transparent"]4.7
[/td]
[td="class: Xl67, bgcolor: Transparent"]6
[/td]
[td="class: Xl67, bgcolor: Transparent"]7.3
[/td]
[td="class: Xl67, bgcolor: Transparent"]8.5
[/td]
[td="class: Xl67, bgcolor: Transparent"]9.7
[/td]
[td="class: Xl67, bgcolor: Transparent"]10.9
[/td]
[td="class: Xl67, bgcolor: Transparent"]12.1
[/td]
[td="class: Xl67, bgcolor: Transparent"]13.4
[/td]
[/tr]
[tr]
[td="class: Xl65, bgcolor: Transparent, align: Right"]1.5
[/td]
[td="class: Xl65, bgcolor: Transparent, align: Right"]1
[/td]
[td="class: Xl67, bgcolor: Transparent"]1.7
[/td]
[td="class: Xl67, bgcolor: Transparent"]3
[/td]
[td="class: Xl67, bgcolor: Transparent"]4.2
[/td]
[td="class: Xl67, bgcolor: Transparent"]5.5
[/td]
[td="class: Xl67, bgcolor: Transparent"]6.8
[/td]
[td="class: Xl67, bgcolor: Transparent"]8
[/td]
[td="class: Xl67, bgcolor: Transparent"]9.2
[/td]
[td="class: Xl67, bgcolor: Transparent"]10.4
[/td]
[/tr]
[tr]
[td="class: Xl65, bgcolor: Transparent, align: Right"]1.5
[/td]
[td="class: Xl65, bgcolor: Transparent, align: Right"]0.5
[/td]
[td="class: Xl67, bgcolor: Transparent"]0.2
[/td]
[td="class: Xl67, bgcolor: Transparent"]1.5
[/td]
[td="class: Xl67, bgcolor: Transparent"]2.7
[/td]
[td="class: Xl67, bgcolor: Transparent"]4
[/td]
[td="class: Xl67, bgcolor: Transparent"]5.2
[/td]
[td="class: Xl67, bgcolor: Transparent"]6.5
[/td]
[td="class: Xl67, bgcolor: Transparent"]7.7
[/td]
[td="class: Xl67, bgcolor: Transparent"]8.9
[/td]
[/tr]
[tr]
[td="class: Xl65, bgcolor: Transparent, align: Right"]1.5
[/td]
[td="class: Xl65, bgcolor: Transparent, align: Right"][/td]
[td="class: Xl67, bgcolor: Transparent"]-1.2
[/td]
[td="class: Xl67, bgcolor: Transparent"][/td]
[td="class: Xl67, bgcolor: Transparent"]1.2
[/td]
[td="class: Xl67, bgcolor: Transparent"]2.5
[/td]
[td="class: Xl67, bgcolor: Transparent"]3.7
[/td]
[td="class: Xl67, bgcolor: Transparent"]5
[/td]
[td="class: Xl67, bgcolor: Transparent"]6.3
[/td]
[td="class: Xl67, bgcolor: Transparent"]7.5
[/td]
[/tr]
[tr]
[td="class: Xl65, bgcolor: Transparent, align: Right"]1.5
[/td]
[td="class: Xl65, bgcolor: Transparent, align: Right"]-0.5
[/td]
[td="class: Xl67, bgcolor: Transparent"]-2.7
[/td]
[td="class: Xl67, bgcolor: Transparent"]-1.4
[/td]
[td="class: Xl67, bgcolor: Transparent"]-0.2
[/td]
[td="class: Xl67, bgcolor: Transparent"]1
[/td]
[td="class: Xl67, bgcolor: Transparent"]2.3
[/td]
[td="class: Xl67, bgcolor: Transparent"]3.5
[/td]
[td="class: Xl67, bgcolor: Transparent"]4.8
[/td]
[td="class: Xl67, bgcolor: Transparent"]6
[/td]
[/tr]
[tr]
[td="class: Xl65, bgcolor: Transparent, align: Right"]1.5
[/td]
[td="class: Xl65, bgcolor: Transparent, align: Right"]-1
[/td]
[td="class: Xl67, bgcolor: Transparent"]-4
[/td]
[td="class: Xl67, bgcolor: Transparent"]-2.8
[/td]
[td="class: Xl67, bgcolor: Transparent"]-1.6
[/td]
[td="class: Xl67, bgcolor: Transparent"]-0.4
[/td]
[td="class: Xl67, bgcolor: Transparent"]0.8
[/td]
[td="class: Xl67, bgcolor: Transparent"]2.1
[/td]
[td="class: Xl67, bgcolor: Transparent"]3.3
[/td]
[td="class: Xl67, bgcolor: Transparent"]4.6
[/td]
[/tr]
[tr]
[td="class: Xl65, bgcolor: Transparent, align: Right"]1.5
[/td]
[td="class: Xl65, bgcolor: Transparent, align: Right"]-2
[/td]
[td="class: Xl67, bgcolor: Transparent"]-6.8
[/td]
[td="class: Xl67, bgcolor: Transparent"]-5.6
[/td]
[td="class: Xl67, bgcolor: Transparent"]-4.4
[/td]
[td="class: Xl67, bgcolor: Transparent"]-3.2
[/td]
[td="class: Xl67, bgcolor: Transparent"]-2
[/td]
[td="class: Xl67, bgcolor: Transparent"]-0.8
[/td]
[td="class: Xl67, bgcolor: Transparent"]0.5
[/td]
[td="class: Xl67, bgcolor: Transparent"]1.7
[/td]
[/tr]
[tr]
[td="class: Xl65, bgcolor: Transparent, align: Right"]1.5
[/td]
[td="class: Xl65, bgcolor: Transparent, align: Right"]-3
[/td]
[td="class: Xl67, bgcolor: Transparent"]-9.4
[/td]
[td="class: Xl67, bgcolor: Transparent"]-8.2
[/td]
[td="class: Xl67, bgcolor: Transparent"]-7
[/td]
[td="class: Xl67, bgcolor: Transparent"]-5.9
[/td]
[td="class: Xl67, bgcolor: Transparent"]-4.7
[/td]
[td="class: Xl67, bgcolor: Transparent"]-3.5
[/td]
[td="class: Xl67, bgcolor: Transparent"]-2.3
[/td]
[td="class: Xl67, bgcolor: Transparent"]-1.1
[/td]
[/tr]
[tr]
[td="class: Xl65, bgcolor: Transparent"][/td]
[td="class: Xl65, bgcolor: Transparent"][/td]
[td="class: Xl67, bgcolor: Transparent"][/td]
[td="class: Xl67, bgcolor: Transparent"][/td]
[td="class: Xl67, bgcolor: Transparent"][/td]
[td="class: Xl67, bgcolor: Transparent"][/td]
[td="class: Xl67, bgcolor: Transparent"][/td]
[td="class: Xl67, bgcolor: Transparent"][/td]
[td="class: Xl67, bgcolor: Transparent"][/td]
[td="class: Xl65, bgcolor: Transparent"][/td]
[/tr]
[tr]
[td="class: Xl65, bgcolor: Transparent, align: Right"]2
[/td]
[td="class: Xl65, bgcolor: Transparent, align: Right"]3
[/td]
[td="class: Xl67, bgcolor: Transparent"]8.1
[/td]
[td="class: Xl67, bgcolor: Transparent"]9.4
[/td]
[td="class: Xl67, bgcolor: Transparent"]10.7
[/td]
[td="class: Xl67, bgcolor: Transparent"]12.1
[/td]
[td="class: Xl67, bgcolor: Transparent"]13.4
[/td]
[td="class: Xl67, bgcolor: Transparent"]14.8
[/td]
[td="class: Xl67, bgcolor: Transparent"]16.1
[/td]
[td="class: Xl67, bgcolor: Transparent"]17.4
[/td]
[/tr]
[tr]
[td="class: Xl65, bgcolor: Transparent, align: Right"]2
[/td]
[td="class: Xl65, bgcolor: Transparent, align: Right"]2
[/td]
[td="class: Xl67, bgcolor: Transparent"]4.9
[/td]
[td="class: Xl67, bgcolor: Transparent"]6.2
[/td]
[td="class: Xl67, bgcolor: Transparent"]7.5
[/td]
[td="class: Xl67, bgcolor: Transparent"]8.8
[/td]
[td="class: Xl67, bgcolor: Transparent"]10.1
[/td]
[td="class: Xl67, bgcolor: Transparent"]11.5
[/td]
[td="class: Xl67, bgcolor: Transparent"]12.8
[/td]
[td="class: Xl67, bgcolor: Transparent"]14.1
[/td]
[/tr]
[tr]
[td="class: Xl65, bgcolor: Transparent, align: Right"]2
[/td]
[td="class: Xl65, bgcolor: Transparent, align: Right"]1
[/td]
[td="class: Xl67, bgcolor: Transparent"]1.8
[/td]
[td="class: Xl67, bgcolor: Transparent"]3.1
[/td]
[td="class: Xl67, bgcolor: Transparent"]4.4
[/td]
[td="class: Xl67, bgcolor: Transparent"]5.6
[/td]
[td="class: Xl67, bgcolor: Transparent"]6.9
[/td]
[td="class: Xl67, bgcolor: Transparent"]8.3
[/td]
[td="class: Xl67, bgcolor: Transparent"]9.6
[/td]
[td="class: Xl67, bgcolor: Transparent"]10.9
[/td]
[/tr]
[tr]
[td="class: Xl65, bgcolor: Transparent, align: Right"]2
[/td]
[td="class: Xl65, bgcolor: Transparent, align: Right"]0.5
[/td]
[td="class: Xl67, bgcolor: Transparent"]0.2
[/td]
[td="class: Xl67, bgcolor: Transparent"]1.5
[/td]
[td="class: Xl67, bgcolor: Transparent"]2.8
[/td]
[td="class: Xl67, bgcolor: Transparent"]4.1
[/td]
[td="class: Xl67, bgcolor: Transparent"]5.4
[/td]
[td="class: Xl67, bgcolor: Transparent"]6.7
[/td]
[td="class: Xl67, bgcolor: Transparent"]8
[/td]
[td="class: Xl67, bgcolor: Transparent"]9.3
[/td]
[/tr]
[tr]
[td="class: Xl65, bgcolor: Transparent, align: Right"]2
[/td]
[td="class: Xl65, bgcolor: Transparent, align: Right"][/td]
[td="class: Xl67, bgcolor: Transparent"]-1.3
[/td]
[td="class: Xl67, bgcolor: Transparent"][/td]
[td="class: Xl67, bgcolor: Transparent"]1.3
[/td]
[td="class: Xl67, bgcolor: Transparent"]2.5
[/td]
[td="class: Xl67, bgcolor: Transparent"]3.8
[/td]
[td="class: Xl67, bgcolor: Transparent"]5.1
[/td]
[td="class: Xl67, bgcolor: Transparent"]6.4
[/td]
[td="class: Xl67, bgcolor: Transparent"]7.7
[/td]
[/tr]
[tr]
[td="class: Xl65, bgcolor: Transparent, align: Right"]2
[/td]
[td="class: Xl65, bgcolor: Transparent, align: Right"]-0.5
[/td]
[td="class: Xl67, bgcolor: Transparent"]-2.8
[/td]
[td="class: Xl67, bgcolor: Transparent"]-1.5
[/td]
[td="class: Xl67, bgcolor: Transparent"]-0.2
[/td]
[td="class: Xl67, bgcolor: Transparent"]1
[/td]
[td="class: Xl67, bgcolor: Transparent"]2.3
[/td]
[td="class: Xl67, bgcolor: Transparent"]3.6
[/td]
[td="class: Xl67, bgcolor: Transparent"]4.9
[/td]
[td="class: Xl67, bgcolor: Transparent"]6.2
[/td]
[/tr]
[tr]
[td="class: Xl65, bgcolor: Transparent, align: Right"]2
[/td]
[td="class: Xl65, bgcolor: Transparent, align: Right"]-1
[/td]
[td="class: Xl67, bgcolor: Transparent"]-4.2
[/td]
[td="class: Xl67, bgcolor: Transparent"]-3
[/td]
[td="class: Xl67, bgcolor: Transparent"]-1.7
[/td]
[td="class: Xl67, bgcolor: Transparent"]-0.5
[/td]
[td="class: Xl67, bgcolor: Transparent"]0.8
[/td]
[td="class: Xl67, bgcolor: Transparent"]2.1
[/td]
[td="class: Xl67, bgcolor: Transparent"]3.3
[/td]
[td="class: Xl67, bgcolor: Transparent"]4.6
[/td]
[/tr]
[tr]
[td="class: Xl65, bgcolor: Transparent, align: Right"]2
[/td]
[td="class: Xl65, bgcolor: Transparent, align: Right"]-2
[/td]
[td="class: Xl67, bgcolor: Transparent"]-7.1
[/td]
[td="class: Xl67, bgcolor: Transparent"]-5.9
[/td]
[td="class: Xl67, bgcolor: Transparent"]-4.7
[/td]
[td="class: Xl67, bgcolor: Transparent"]-3.4
[/td]
[td="class: Xl67, bgcolor: Transparent"]-2.2
[/td]
[td="class: Xl67, bgcolor: Transparent"]-0.9
[/td]
[td="class: Xl67, bgcolor: Transparent"]0.3
[/td]
[td="class: Xl67, bgcolor: Transparent"]1.6
[/td]
[/tr]
[tr]
[td="class: Xl65, bgcolor: Transparent, align: Right"]2
[/td]
[td="class: Xl65, bgcolor: Transparent, align: Right"]-3
[/td]
[td="class: Xl67, bgcolor: Transparent"]-10
[/td]
[td="class: Xl67, bgcolor: Transparent"]-8.8
[/td]
[td="class: Xl67, bgcolor: Transparent"]-7.6
[/td]
[td="class: Xl67, bgcolor: Transparent"]-6.3
[/td]
[td="class: Xl67, bgcolor: Transparent"]-5.1
[/td]
[td="class: Xl67, bgcolor: Transparent"]-3.9
[/td]
[td="class: Xl67, bgcolor: Transparent"]-2.6
[/td]
[td="class: Xl67, bgcolor: Transparent"]-1.4
[/td]
[/tr]
</tbody>[/table]

cyrilbrd · Mar 24, 2014

Not sure if this is what you want, given in a1 the table posted above.

In A45 :

<style>table { }td { padding-top: 1px; padding-right: 1px; padding-left: 1px; color: black; font-size: 12pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Calibri,sans-serif; vertical-align: bottom; border: medium none; white-space: nowrap; }.xl63 { font-size: 11pt; font-family: "Calibri (Body)"; }</style> [TABLE="width: 130"]
<colgroup><col style="width:65pt" span="2" width="65"> </colgroup><tbody>[TR]
[TD="width: 65, bgcolor: transparent"]sounding[/TD]
[TD="width: 65, align: right"]1[/TD]
[/TR]
[TR]
[TD]heel/ trim[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]range[/TD]
[TD="class: xl63, align: right"]2[/TD]
[/TR]
[TR]
[TD]result[/TD]
[TD="class: xl63, align: right"]6.8[/TD]
[/TR]
</tbody>[/TABLE]

formula in B48 could be =INDEX($C$2:$J$40,MATCH(1,INDEX(($B$2:$B$40=B46)*($A$2:$A$40=B45),0),0),MATCH(B47,$C$1:$J$1,0))

Would that work for you?

Peter_SSs · Mar 24, 2014

If the question has not already been answered, what are the expected results and how do you get them?

rajeshasv · Apr 1, 2014

cyrilbrd said:
Not sure if this is what you want, given in a1 the table posted above.

In A45 :

<STYLE>table { }td { padding-top: 1px; padding-right: 1px; padding-left: 1px; color: black; font-size: 12pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Calibri,sans-serif; vertical-align: bottom; border: medium none; white-space: nowrap; }.xl63 { font-size: 11pt; font-family: "Calibri (Body)"; }</STYLE>[TABLE="width: 130"]
<TBODY>[TR]
[TD="width: 65, bgcolor: transparent"]sounding
[/TD]
[TD="width: 65, align: right"]1
[/TD]
[/TR]
[TR]
[TD]heel/ trim
[/TD]
[TD="align: right"]2
[/TD]
[/TR]
[TR]
[TD]range
[/TD]
[TD="class: xl63, align: right"]2
[/TD]
[/TR]
[TR]
[TD]result
[/TD]
[TD="class: xl63, align: right"]6.8
[/TD]
[/TR]
</TBODY>[/TABLE]

formula in B48 could be =INDEX($C$2:$J$40,MATCH(1,INDEX(($B$2:$B$40=B46)*($A$2:$A$40=B45),0),0),MATCH(B47,$C$1:$J$1,0))

Would that work for you?

hello

appreciate your reply
i want values of table
i put these values manually now but how to get by formula???
[TABLE="width: 322"]
<COLGROUP><COL style="WIDTH: 91pt; mso-width-source: userset; mso-width-alt: 2761" width=121><COL style="WIDTH: 77pt" span=3 width=102><TBODY>[TR]
[TD="width: 121, bgcolor: transparent"]for heel [/TD]
[TD="class: xl73, width: 102, bgcolor: transparent"]0[/TD]
[TD="width: 102, bgcolor: transparent"][/TD]
[TD="width: 102, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: white"]sounding/trim[/TD]
[TD="class: xl64, bgcolor: #ffff99"]0[/TD]
[TD="class: xl65, bgcolor: #ffff99"]1.00[/TD]
[TD="class: xl64, bgcolor: #ffff99"]2[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #ffff99"]0.5[/TD]
[TD="class: xl64, bgcolor: #ffff99"]0[/TD]
[TD="class: xl66, bgcolor: #ffff99"]1.1[/TD]
[TD="class: xl66, bgcolor: #ffff99"]2.2[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: #92d050"]1.5[/TD]
[TD="class: xl68, bgcolor: #92d050"]0[/TD]
[TD="class: xl69, bgcolor: #92d050"]1.20[/TD]
[TD="class: xl70, bgcolor: #92d050"]2.500[/TD]
[/TR]
[TR]
[TD="class: xl71, bgcolor: #92d050"]2[/TD]
[TD="class: xl67, bgcolor: #92d050"]0[/TD]
[TD="class: xl72, bgcolor: #92d050"]1.30[/TD]
[TD="class: xl67, bgcolor: #92d050"]2.5[/TD]
[/TR]
[TR]
[TD="class: xl71, bgcolor: #92d050"][/TD]
[TD="class: xl67, bgcolor: #92d050"][/TD]
[TD="class: xl72, bgcolor: #92d050"][/TD]
[TD="class: xl67, bgcolor: #92d050"][/TD]
[/TR]
</TBODY>[/TABLE]

cyrilbrd · Apr 1, 2014

Given in M4:
[TABLE="class: grid, width: 412"]
<tbody>[TR]
[TD]heel
[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]sounding[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="align: right"]0.5[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1.2[/TD]
[TD="align: right"]2.3[/TD]
[/TR]
[TR]
[TD="align: right"]1.5[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1.2[/TD]
[TD="align: right"]2.5[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1.3[/TD]
[TD="align: right"]2.5[/TD]
[/TR]
</tbody>[/TABLE]

Formula in N6 is =INDEX($C$2:$J$40,MATCH(1,INDEX(($B$2:$B$40=$N$4)*($A$2:$A$40=$M6),0),0),MATCH(N$5,$C$1:$J$1,0)) copied right and down till needed.

Would that work for you?

Peter_SSs · Apr 2, 2014

... or this, copied across and down?

Excel Workbook

A

B

C

D

E

F

G

H

I

J

1

sounding

heel/trim

-1

0

1

2

3

4

5

6

2

0.5

3

4

5.2

6.5

7.8

9.1

10.5

11.9

13.1

3

0.5

2

2.2

3.4

4.6

5.9

7.1

8.5

9.8

11.1

4

0.5

1

0.5

1.6

2.8

4

5.3

6.6

7.8

9.2

5

0.5

-0.4

0.8

2

3.2

4.4

5.7

6.9

8.2

6

0.5

-1.1

1.2

2.3

3.5

4.8

6

7.3

7

0.5

-0.5

-1.9

-0.8

0.4

1.5

2.7

3.9

5.2

6.4

8

0.5

-1

-2.6

-1.5

-0.4

0.8

1.9

3.1

4.3

5.6

9

0.5

-2

-4

-2.9

-1.8

-0.7

0.4

1.6

2.8

4

10

0.5

-3

-5.3

-4.2

-3.2

-2.1

-1

0.1

1.3

2.5

11

12

1

3

5.7

6.9

8.1

9.3

10.5

11.7

12.9

14.2

13

1

2

3.3

4.5

5.6

6.8

8

9.2

10.4

11.6

14

1

1.1

2.2

3.3

4.4

5.6

6.8

7.9

9.1

15

1

0.5

1.1

2.2

3.3

4.5

5.6

6.8

8

16

1

-1.3

1.1

2.2

3.3

4.5

5.6

6.8

17

1

-0.5

-2.5

-1.2

1.2

2.3

3.4

4.5

5.7

18

1

-1

-3.7

-2.4

-1.1

0.1

1.2

2.3

3.4

4.6

19

1

-2

-5.9

-4.7

-3.5

-2.2

-0.9

0.3

1.4

2.5

20

1

-3

-8.1

-6.9

-5.7

-4.5

-3.2

-2

-0.7

0.5

21

22

1.5

3

7.7

9

10.2

11.4

12.6

13.8

15.1

16.3

23

1.5

2

4.7

6

7.3

8.5

9.7

10.9

12.1

13.4

24

1.5

1

1.7

3

4.2

5.5

6.8

8

9.2

10.4

25

1.5

0.5

0.2

1.5

2.7

4

5.2

6.5

7.7

8.9

26

1.5

-1.2

1.2

2.5

3.7

5

6.3

7.5

27

1.5

-0.5

-2.7

-1.4

-0.2

1

2.3

3.5

4.8

6

28

1.5

-1

-4

-2.8

-1.6

-0.4

0.8

2.1

3.3

4.6

29

1.5

-2

-6.8

-5.6

-4.4

-3.2

-2

-0.8

0.5

1.7

30

1.5

-3

-9.4

-8.2

-7

-5.9

-4.7

-3.5

-2.3

-1.1

31

32

2

3

8.1

9.4

10.7

12.1

13.4

14.8

16.1

17.4

33

2

4.9

6.2

7.5

8.8

10.1

11.5

12.8

14.1

34

2

1

1.8

3.1

4.4

5.6

6.9

8.3

9.6

10.9

35

2

0.5

0.2

1.5

2.8

4.1

5.4

6.7

8

9.3

36

2

-1.3

1.3

2.5

3.8

5.1

6.4

7.7

37

2

-0.5

-2.8

-1.5

-0.2

1

2.3

3.6

4.9

6.2

38

2

-1

-4.2

-3

-1.7

-0.5

0.8

2.1

3.3

4.6

39

2

-2

-7.1

-5.9

-4.7

-3.4

-2.2

-0.9

0.3

1.6

40

2

-3

-10

-8.8

-7.6

-6.3

-5.1

-3.9

-2.6

-1.4

41

42

for heel

0

43

sounding/trim

0

1

2

44

0.5

0

1.2

2.3

45

1.5

0

1.2

2.5

46

2

0

1.3

2.5

Extract from table

Getting data from table with three variables

rajeshasv

New Member

Excel Facts

cyrilbrd

Well-known Member

Peter_SSs

MrExcel MVP, Moderator

rajeshasv

New Member

cyrilbrd

Well-known Member

Peter_SSs

MrExcel MVP, Moderator

Similar threads

Forum statistics

Share this page

Getting data from table with three variables

rajeshasv

New Member

Excel Facts

cyrilbrd

Well-known Member

Peter_SSs

MrExcel MVP, Moderator

rajeshasv

New Member

cyrilbrd

Well-known Member

Peter_SSs

MrExcel MVP, Moderator

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock