data retrival
 

how can i enter a number(say2006) & have excell look in table2006

data retrival
 

jimmy

Much more detail is needed before an answer can be attempted.

Where is table2006?

Where would you enter the number 2006?

What would you look for in table2006?


Gord Dibben MS Excel MVP

On Sat, 22 Jul 2006 09:16:01 -0700, jimmy
wrote:

how can i enter a number(say2006) & have excell look in table2006

data retrival
 

if the tables are in the same book using names and the indirect function may
do the trick
--
paul

remove nospam for email addy!



"jimmy" wrote:

how can i enter a number(say2006) & have excell look in table2006

data retrival
 

my problem is having the lookup function go to the correct table.i require
entering the year into a cell then attemt to link the value in that cell(
lets say the number 2006) to the table2006.I can get it to work if I enter
table2006,table2007,etc.,but I want to be able to enterjust a number and go
to correct table.Another thing I can't figure out want is used in the name
box "text","number",what?
Thanks,Jim
"Gord Dibben" wrote:

jimmy

Much more detail is needed before an answer can be attempted.

Where is table2006?

Where would you enter the number 2006?

What would you look for in table2006?


Gord Dibben MS Excel MVP

On Sat, 22 Jul 2006 09:16:01 -0700, jimmy
wrote:

how can i enter a number(say2006) & have excell look in table2006