Table References



I have 3 Tables, i.e. T1, T2 and T3 defined as cell ranges with the same
number of rows/columns, different cell values. I want the user to select a
table, then select a row value and column value. I use the row and column
values to create indexes into the table and retrieve a cell value.

I use a cell Data Validation with a list value of T1, T2 and T3 for the user
to select a table (and select the row and column values).

How do I convert the Data Validation string value of T1, T2 or T3 to the
appropriate table reference? Once I have the table reference, I can use the
row/column values to index the table.

Please submit any better solutions you may have.


Tom Ogilvy

That assumed that you had names defined (insert=>Name=>Define) to identify
your tables. It was assumed that those names were T1, T2 and T3, but Excel
wouldn't let you use those names because they could be confused with cell
references. You could name your tables something like TableT1, TableT2,
TableT3. Then if you use indirect and the cell will hold T1, T2 or T3 in A1

=Indirect("Table" & A1)

Tom Ogilvy

Alan said:

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