Trying to find values from header of colums and rows, from table.

[ljubo_gr]

So this is previous formula: =IF(AND(B5>=0,B5<241.1),(INDEX('S-7'!B15:K41,MATCH(TRUNC(B5)+1,'S-7'!A15:A42,1),MATCH(MOD(TRUNC(B5)+1,10),'S-7'!B14:K14,0))-INDEX('S-7'!B15:K41,MATCH(TRUNC(B5),'S-7'!A15:A42,1),MATCH(MOD(TRUNC(B5),10),'S-7'!B14:K14,0)))*(B5-TRUNC(B5))+INDEX('S-7'!B15:K41,MATCH(TRUNC(B5),'S-7'!A15:A42,1),MATCH(MOD(TRUNC(B5),10),'S-7'!B14:K14,0)),"ERROR")

this formula is doing: (example: 100.1cm) that is 19,024 - 18,763 = 261 * 0.1 + 18,763 returns 18,789litres
So, khmm, khmm: Please, now i need to find height in reservoire for, let's say, 33 333Litres!? Please, help, or give guidelines.

Here's excel workbook:

http://www.datafilehost.com/d/4dcef703

Thank you in advance!

 

[ljubo_gr]

So this is previous formula: =IF(AND(B5>=0,B5<241.1),(INDEX('S-7'!B15:K41,MATCH(TRUNC(B5)+1,'S-7'!A15:A42,1),MATCH(MOD(TRUNC(B5)+1,10),'S-7'!B14:K14,0))-INDEX('S-7'!B15:K41,MATCH(TRUNC(B5),'S-7'!A15:A42,1),MATCH(MOD(TRUNC(B5),10),'S-7'!B14:K14,0)))*(B5-TRUNC(B5))+INDEX('S-7'!B15:K41,MATCH(TRUNC(B5),'S-7'!A15:A42,1),MATCH(MOD(TRUNC(B5),10),'S-7'!B14:K14,0)),"ERROR")

this formula is doing: (example: 100.1cm) that is 19,024 - 18,763 = 261 * 0.1 + 18,763 returns 18,789litres
So, khmm, khmm: Please, now i need to find height in reservoire for, let's say, 33 333Litres!? Please, help, or give guidelines.

Here's excel workbook:

http://www.datafilehost.com/d/4dcef703

Thank you in advance!

pl

 

[ljubo_gr]

Please, i begg... anyone...