G'day Andy

I think a Lookup array will be what your looking for, as it appears in your
example that each tank has the same values throughout.

I have created an example worksheet for you to look at and play with.

It is normal practice within the NG to post responses, and never attach
files.

This in mind, you or anyone who has a similar requirement can send an email
to and I will forward you the file.

HTH
Mark.