| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Use INDIRECT function to reference a value in closed file
Book1.xls - Cell C3 = CONCATENATE("'",E:\Saravan\Jun2005,"\[Book2.xls]Sheet1'!$A$4:$B$18") Book1.xls - Cell A4:A13 have dates (01-jun-2005 to 10-jun-2005) Book1.xls - Cell B4:B13 should lookup a value corresponding to the date in Book2.xls I have tried "=VLOOKUP(A4,INDIRECT(C3),2,FALSE)", Seems to work only with open work books. Is there any function that could be used on closed workbooks. Saravan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| indirect cell reference using copies of worksheets in same workboo | Excel Worksheet Functions | |||
| MIN Function w/ variable address reference | Excel Worksheet Functions | |||
| Using INDIRECT function to specify source data | Charts and Charting in Excel | |||
| referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
| Dynamic Function Reference Question | Excel Discussion (Misc queries) | |||
Threaded Mode
