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
use

=Indirect("Table" & A1)

--
Regards,
Tom Ogilvy

"Alan" wrote in message
...
thanks.

"Tom Ogilvy" wrote:

Indirect(A1)

where A1 holds T1, T2 or T3

--
Regards,
Tom Ogilvy