I have

Numerous tank tables (tanks containing liquids) with 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

    A    B    C    D    E    F
1    Tank 25    Sounding   Volume    VCG    LCG    TCG
2        1.00    140.00    0.50    52.50    20.00
3        1.50    219.00    0.75    56.88    22.50
4        2.00    298.00    1.00    61.25    25.00
5        2.50    377.00    1.25    65.63    27.50
6        3.00    456.00    1.50    70.00    30.00
7                       
8    Tank 26    Sounding   Volume    VCG    LCG    TCG
9        1.00    140.00    0.50    52.50    20.00
10        1.50    219.00    0.75    56.88    22.50
11        2.00    298.00    1.00    61.25    25.00
12        2.50    377.00    1.25    65.63    27.50
13        3.00    456.00    1.50    70.00    30.00
14                       
15    Tank 27    Sounding   Volume    VCG    LCG    TCG
16        1.00    140.00    0.50    52.50    20.00
17        1.50    219.00    0.75    56.88    22.50
18        2.00    298.00    1.00    61.25    25.00
19        2.50    377.00    1.25    65.63    27.50
20        3.00    456.00    1.50    70.00    30.00
21                       
22    Summary    Sounding   Volume    VCG    LCG    TCG
23    Tank 25    2.50    377.00    1.25    65.63    27.50
24    Tank 26    2.00    298.00    1.00    61.25    25.00
25    Tank 27    3.00    456.00    1.50    70.00    30.00
26            1131.00