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