Rais Ahmed
New Member
- Joined
- Oct 8, 2016
- Messages
- 7
Hi Every one,
I had one very good and almost accurate excel formula for calculating a specific value by index and match function. I lost my external hard drive and that formula too. Can body body help me to do that formula again as I almost not working on excel over two year and above. What I need to calculate value between to 2 number based on another value. As you can see below H is Height and A is some value relative to specific value in column H. If I want to calculate value of A based on H = 4 what should be formula. Thank you for your time reading this.
<colgroup><col style="width:48pt" width="64" span="2"> </colgroup><tbody>
</tbody>
I had one very good and almost accurate excel formula for calculating a specific value by index and match function. I lost my external hard drive and that formula too. Can body body help me to do that formula again as I almost not working on excel over two year and above. What I need to calculate value between to 2 number based on another value. As you can see below H is Height and A is some value relative to specific value in column H. If I want to calculate value of A based on H = 4 what should be formula. Thank you for your time reading this.
H | A |
3 | 0.83 |
5 | 0.88 |
10 | 1 |
15 | 1.03 |
20 | 1.06 |
30 | 1.09 |
40 | 1.12 |
50 | 1.14 |
60 | 1.15 |
80 | 1.18 |
100 | 1.2 |
120 | 1.22 |
<colgroup><col style="width:48pt" width="64" span="2"> </colgroup><tbody>
</tbody>