good day everyone! I have this calibration table

16176606_2205094596381638_1732582375_n.jpg

I would like to create a worksheet where I can just input the height and obtain the corresponding output.
i.e. if I input a height of 40.2 cm, I will obtain a volume 501 liters (see picture)

Another problem is that the table isnt complete, if you'll notice, only even numbers are displayed in the mm column.
If I had to obtain the volume for a height of 40.3, I would have to interpolate by getting the average of the corresponding volumes of 40.4 and 40.2

Calculating the values beforehand isnt an option for me since i have around a thousand rows. I would like the worksheet to be able to interpolate the values.

would this be possible in excel? do i need to learn vba? Please point me in the proper direction.

Thank you very much.