| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
data retrival
how can i enter a number(say2006) & have excell look in table2006
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pull data from another sheet based on certain criteria | Excel Discussion (Misc queries) | |||
| Importing Data | Excel Worksheet Functions | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| Saving data in a worksheet within a workbook | Excel Discussion (Misc queries) | |||
| Line Graph Data Recognition | Charts and Charting in Excel | |||
Hybrid Mode
