Mangesh,

I have come across your response to this thread and you're obviously the
person I need to communicate with. I have tried to use your formula but as
yet have got nowhere.

I have a similar query, I need to interpolate for a value in a table in this
case tank volumes and other info.

Depth of water is in 20 cm increments in col A with volume and other info
in cols B through E I would like to extract info from any given 1 cm
increment .

Alternatively I can do the maths if someone can tell me how to get the cell
above and below my required value in col A for vlookup.

Many thanks

Ben

"mangesh_yadav" wrote:


You are probably looking for this (interpolation) formula:

=(C2-LOOKUP(C2,$A$2:$A$12))/(INDEX($A$2:$B$12,MATCH(C2,$A$2:$A$12,1)+1,1)-LOOKUP(C2,$A$2:$A$12))*(INDEX($A$2:$B$12,MATCH(C2, $A$2:$A$12,1)+1,2)-LOOKUP(C2,$A$2:$A$12,$B$2:$B$12))+LOOKUP(C2,$A$2:$ A$12,$B$2:$B$12)

Substitute A12 or B12 with your last row 151.

Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=380042