mfaisal.ce
New member
- Joined
- Nov 26, 2021
- Messages
- 1
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2010
Hello,
I am trying to find a value between a range but unable to do that, i tried Index & match combination too but unable....
Level 0 10 20 30 40 50 60 70 80 90 100
Volume 0 0.34 0.97 1.75 2.63 3.55 4.47 5.35 6.13 6.76 7.1
I need to find Volume when Level will be 35? I want to use Level and Volume in dynamic range....
Please give me the solution....
regards,
I am trying to find a value between a range but unable to do that, i tried Index & match combination too but unable....
Level 0 10 20 30 40 50 60 70 80 90 100
Volume 0 0.34 0.97 1.75 2.63 3.55 4.47 5.35 6.13 6.76 7.1
I need to find Volume when Level will be 35? I want to use Level and Volume in dynamic range....
Please give me the solution....
regards,