Forum Discussion

remmuS407's avatar
remmuS407
Copper Contributor
Apr 20, 2024
Solved

Table consolidation

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 ...
excel
  • rachel's avatar
    rachel
    Apr 21, 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.

     

     

  • remmuS407's avatar
    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's avatar
      rachel
      Steel Contributor
      Apr 21, 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.

       

       

      • remmuS407's avatar
        remmuS407
        Copper Contributor
        Apr 23, 2024
        Thank you! That did the trick! Saved me from the mess of the IF AND statements I was previously using as a bandaid