J
jimmy
how can i enter a number(say2006) & have excell look in table2006
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
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
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
P
paul
if the tables are in the same book using names and the indirect function may
do the trick
do the trick
J
jimmy
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
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