| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Offset on closed file
In Excel2000, I have an Offset formula that works on a closed file.I
have read that the Offset function does not work on closed files. How else can I do this? I don't want to use a Vlookup or Index Match because of the way the data is layed out in the source file ( many tabs with data all over the place).My formula is below: =OFFSET('[Jul06 Ebit-STD.xls]RTW'!$I$4,0,2) thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| File A and File B Together | Excel Discussion (Misc queries) | |||
| disc full, saved to temp. file | Excel Discussion (Misc queries) | |||
| I closed a file without saving it, can i recover the information? | Excel Discussion (Misc queries) | |||
| can i recover a file i didnt save nor have i closed out? | Excel Worksheet Functions | |||
| Weird File Open/Save As Behavior | Excel Discussion (Misc queries) | |||
Linear Mode
