Forum Discussion

remmuS407's avatar
remmuS407
Copper Contributor
Apr 21, 2024

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 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.

     

     

rachel's avatar
rachel
Steel Contributor

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
  • rachel's avatar
    rachel
    Steel Contributor
    Apr 24, 2024
    You are welcome. Respect for using nested ifs on 9 tables!

Resources