How to use cell contents to indirectly reference other tables?
I think I need to use the INDIRECT or ADDRESS function here, but I just can’t seem to structure it right. Does anyone have ideas? I have a model that uses multiple tables, and I want to be able to enter table names, column names and row names into a new table, and for it to go and look up the right value in that TABLE::ROW NAME, COLUMN NAME. In more detail: I have a table called SITES that has columns called Site1, Site2 etc, and rows of information such as Name, Phone, etc. I also have a whole series of tables called OPTION1, OPTION2 etc etc, which also have multiple columns for Site1, Site2 etc, and then rows of different information for each site, labelled Alt1, Alt2, Alt3 etc. What I want to do is create new tables for reports, where I can enter eg OptionN in one cell, SiteN in another, and for that table to lookup the value of table OptionN::SiteN AltN. I need this to be built into the formulae partly for data integrity purposes eg, if the table shows Site1 name, and Option1, I ne
