Using 2 cells in a table to retrieve data from another table

A

Andy G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vertical lookup conundrum 4
Setting column width in a table with a macro is not working 0
Format column widths from one table to a separate table on same page 1
Consolidation Table from Different Excel Tabs with Different Format 1
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Refer to a worksheet/name using cell contents? 5
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Word VBA - Automatic change content of a cell in table using dropdown list 5

Top