Calculate the volume of multiple tanks based on the number of the tanks

[meonly123]

I need a formula to calculate the volume in liters based on the number of the tank number in another sheets (CM and MM)

The volume is calculated by looking for the value in column(cm) at the tank sheet and returning the value in another column (liters), and then also add/sum the millimeters value in sheet(MM)
liters to the total of liters as total calculated liters

Please find the attached example

[Pete_UK]

One example is not much to go on, but try this in E5 of the TANKS sheet:

=INDEX(CM!$A$4:$AF$1503,MATCH($C5,CM!$A$4:$A$1503,0),MATCH($B5,CM!$2:$2,0)+1) + INDEX(MM!$A$4:$AH$12,MATCH($D5,MM!$A$4:$A$12,0),MATCH($B5,MM!$2:$2,0)+1)

Copy down as required.

Hope this helps.

Pete

[meonly123]

One example is not much to go on, but try this in E5 of the TANKS sheet:

=INDEX(CM!$A$4:$AF$1503,MATCH($C5,CM!$A$4:$A$1503,0),MATCH($B5,CM!$2:$2,0)+1) + INDEX(MM!$A$4:$AH$12,MATCH($D5,MM!$A$4:$A$12,0),MATCH($B5,MM!$2:$2,0)+1)

Copy down as required.

Hope this helps.

Pete

Thank you very much thats GREAT ... BUT it doesnt work if the mm value is empty or zero , for example 2cm 0mm
also i would like it to recognize between empty cell and zero value ,for example 0 value =2145 liters but empty cell means no value
Thanks for your help

[meonly123]

Plz ignore my previous reply the problem solved ,
Thank you very much Pete_UK

[Pete_UK]

Glad to help, and thanks for the rep.

Pete