Help with lookup formula

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.

ahh yes. Thank you. I will start tinkering with Index match

There is still the issue of having to get values from inputs with odd mm (1,3,5,7,9)
suppose I need to input 40.3, which is between 40.4 and 40.2. I can get the value by getting the average of 501 and 504. Is there a way to get Excel to automate this process?