data retrival

[Guest]

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

 

[Gord Dibben]

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

 

[Guest]

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

 

[Guest]

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