| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dynamic referencing to files
Thanks Max for the follow up..
--Just to add on if 'Sep 09' is a text string entered in cell Z1 try the formula Max offered. If you want an exact match try =VLOOKUP($A1,INDIRECT("'"&Z1&" Update'!A:B"),2,0) --Incase that is a date formatted to view as Sep 09 then you =VLOOKUP($A1,INDIRECT(TEXT(Z1,"""'""mmm yy"" Update'!A:B""")),2,0) If this post helps click Yes --------------- Jacob Skaria "Max" wrote: =VLOOKUP($A1,INDIRECT(Z1&" Update!A:B"),2) I'd always include the possibility of target sheetnames having spaces. Try it like this, with apostrophes: =VLOOKUP($A1,INDIRECT("'"&Z1&" Update'!A:B"),2) Success? hit the YES below -- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Referencing External files with slightly different names | Excel Worksheet Functions | |||
| Dynamic file referencing? | Excel Worksheet Functions | |||
| Creating a Dynamic .XLS file from two other .XLS files | Excel Discussion (Misc queries) | |||
| Referencing Other Files - Formula Pattern? | Excel Discussion (Misc queries) | |||
| Can I post dynamic line charts by swapping out .cvs files??? | Charts and Charting in Excel | |||
Hybrid Mode
