Hello,
I have a set of data as given below
[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]X/Y
[/TD]
[TD]1
[/TD]
[TD]2
[/TD]
[TD]3
[/TD]
[TD]4
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]10
[/TD]
[TD]1.1
[/TD]
[TD]1.3
[/TD]
[TD]1.5
[/TD]
[TD]1.8
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]20
[/TD]
[TD]1.5
[/TD]
[TD]1.6
[/TD]
[TD]1.7
[/TD]
[TD]2
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]30
[/TD]
[TD]1.8
[/TD]
[TD]2
[/TD]
[TD]2.5
[/TD]
[TD]3
[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]40
[/TD]
[TD]1.9
[/TD]
[TD]2.5
[/TD]
[TD]3.2
[/TD]
[TD]4.5
[/TD]
[/TR]
</tbody>[/TABLE]
Another table is to be filled by interpolating from the data above.
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]F
[/TD]
[TD]G
[/TD]
[TD]H
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]X
[/TD]
[TD]Y
[/TD]
[TD]To be Filled
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]11
[/TD]
[TD]1.05
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]13
[/TD]
[TD]1.7
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]15
[/TD]
[TD]1.96
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]22
[/TD]
[TD]2.58
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
How to fill data with interp function? can Vlookup be used for the same??
I have a set of data as given below
[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]X/Y
[/TD]
[TD]1
[/TD]
[TD]2
[/TD]
[TD]3
[/TD]
[TD]4
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]10
[/TD]
[TD]1.1
[/TD]
[TD]1.3
[/TD]
[TD]1.5
[/TD]
[TD]1.8
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]20
[/TD]
[TD]1.5
[/TD]
[TD]1.6
[/TD]
[TD]1.7
[/TD]
[TD]2
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]30
[/TD]
[TD]1.8
[/TD]
[TD]2
[/TD]
[TD]2.5
[/TD]
[TD]3
[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]40
[/TD]
[TD]1.9
[/TD]
[TD]2.5
[/TD]
[TD]3.2
[/TD]
[TD]4.5
[/TD]
[/TR]
</tbody>[/TABLE]
Another table is to be filled by interpolating from the data above.
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]F
[/TD]
[TD]G
[/TD]
[TD]H
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]X
[/TD]
[TD]Y
[/TD]
[TD]To be Filled
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]11
[/TD]
[TD]1.05
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]13
[/TD]
[TD]1.7
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]15
[/TD]
[TD]1.96
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]22
[/TD]
[TD]2.58
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
How to fill data with interp function? can Vlookup be used for the same??