Good morning

I have

Numerous tank tables (tanks containing liquids) with 7 columns, Sounding,
Volume, Centre of gravity, free surface etc

One summary table, to sum the contents from said tanks, with the same
columns as the individual tank tables.

Up to now I have been entering the sounding (column 1) in the summary table
and it has retrieved the data for that sounding from the relevant tank table
using vertical lookup. I would like to enter either the sounding (column 1)
OR the volume (column 2) in the summary table and for excel to extract the
relevant values from the tank table for that sounding/volume. Is it possible
if I have entered the sounding in column one that excel retrieves the data in
all columns including the volume in column two OR if I enter the volume in
column two it retrieves the data in all columns including the sounding in
column one?

Thanks