If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. thanks. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
thanks.
"Tom Ogilvy" wrote: Indirect(A1) where A1 holds T1, T2 or T3 -- Regards, Tom Ogilvy |
#4
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Update Tables using forms | achett | Using Forms | 5 | January 28th, 2005 12:25 AM |
Mixed up with Relationships..help! | KrazyRed | New Users | 3 | January 26th, 2005 05:03 AM |
transpose | john | Using Forms | 1 | November 24th, 2004 06:16 PM |
Manual line break spaces on TOC or Table of tables | Eric | Page Layout | 9 | October 29th, 2004 04:42 PM |
Name not showing ID is | René | Setting Up & Running Reports | 11 | June 29th, 2004 01:40 AM |