Indirect(A1)

where A1 holds T1, T2 or T3

--
Regards,
Tom Ogilvy

"Alan" wrote in message
...
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.

thanks.