Hi. I am currently working on a design spreadsheet where I need to be able to consolidate information from 9 different tables down to 1 table for design reference values based on user selection from drop down lists. The titles and indicators of the tables are already complete, but running into a wall on how to pull over the values.

remmuS407 Thanks a lot for explaining it so clearly! I attached a spreadsheet to show how to use INDIRECT to get tables based on table name or range address string.

Table consolidation | Microsoft Community Hub

rachel
Steel Contributor
Apr 21, 2024
remmuS407

You can try INDIRECT.
https://support.microsoft.com/en-us/office/indirect-function-474b3a3a-8a26-4f44-b491-92b6306fa261
Better paste some of your sample data here.
- remmuS407
  Copper Contributor
  Apr 21, 2024
  rachel So, there are user selection lists in B9 and D9. From those selections, table cells G11:G16 would be populated using data from the following tables: K11:K16, N11:N16, Q11:Q16, K22:K27, N22:N27, Q22:Q27. B2 would determine if values from rows 11:16 are selected, or if values from rows 22:27 are selected. And D9 would determine if values from either columns K, N, or Q are selected.
  - rachel
    Steel Contributor
    Apr 22, 2024
    remmuS407
    
    Thanks a lot for explaining it so clearly!
    
    I attached a spreadsheet to show how to use INDIRECT to get tables based on table name or range address string.
    
    INDIRECT + tables.xlsx15 KB
Harun24HR
Bronze Contributor
Apr 21, 2024
If you are a user of Microsoft 365 then use =VSTACK(Table1,Table2,.......)

Forum Discussion

Table consolidation

Share

Resources