| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking to another spreadsheet in a dynamic way
Hi everyone,
I am using a vlookup function: =VLOOKUP(A25,MV_TD_MT_2004!$A:$G,G$2,FALSE) In this formula will look for the values in spreadsheet MV_TD_MT_2004, columns $A:$G. I have 50+ spreadsheets MV_TD_MT_1953 to MV_TD_MT_2006 Is it possible to make the reference to the spreadsheet with the values in a dynamic way? I am trying to avoid using VBA on this one. Thanks in advance. PA |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Linking to another spreadsheet in a dynamic way
You can use dynamic named ranges. See he
http://www.ozgrid.com/Excel/DynamicRanges.htm Dave -- Brevity is the soul of wit. "alves" wrote: Hi everyone, I am using a vlookup function: =VLOOKUP(A25,MV_TD_MT_2004!$A:$G,G$2,FALSE) In this formula will look for the values in spreadsheet MV_TD_MT_2004, columns $A:$G. I have 50+ spreadsheets MV_TD_MT_1953 to MV_TD_MT_2006 Is it possible to make the reference to the spreadsheet with the values in a dynamic way? I am trying to avoid using VBA on this one. Thanks in advance. PA |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to Extract Data from Spreadsheet | Excel Worksheet Functions | |||
| Linking a form to a spreadsheet | Excel Discussion (Misc queries) | |||
| Need dynamic name range in Excel for Outlook interface | Excel Worksheet Functions | |||
| Linking data between columns in an automatic way with dynamic link | Excel Discussion (Misc queries) | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Linear Mode
