| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change of File name within a cell reference
Thank you very much. You saved me two days of work =). Kostiz you are a star!
"vezerid" wrote: Zuzana, You need something like: =VLOOKUP($A2, INDIRECT("'[New format "&B$1&".xls]sheetname'!A:B"), 2, 0) The INDIRECT() function builds dynamic addresses. $A2 is "dollared" so that the lookup value is always in column A:A. B$1 is dollared so that the date is always in row 1:1. Hopefully all referenced workbooks will have the data in a sheet named identically. Otherwise you might need to have a nested VLOOKUP(), with the sheet names per date. Write back if you need details. HTH Kostis Vezerides |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change a cell range with a reference cell? | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| how do i reference data in a file with the fname in another cell? | Excel Worksheet Functions | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| Weekly Transaction Processing | Excel Worksheet Functions | |||
Threaded Mode
