| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
INDIRECT Function
Hello My file is myfile2006.xls In cell B2 I have the current year 2006. In B5 I am trying to reference last years file [MyFile2005.xls]sheet1!B4. The formula that I am using =indirect("[MyFile"& B2-1 &".xls]Sheet1!" & char(column()+64)&Row()-1) is returning #ref Both files are in the same directory. I understand that indirect will not work with closed files. What am I doing wrong? Thanks -- Sailor4life ------------------------------------------------------------------------ Sailor4life's Profile: http://www.excelforum.com/member.php...o&userid=33723 View this thread: http://www.excelforum.com/showthread...hreadid=535045 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using INDIRECT in INDEX(LINEST.. ) function | Excel Worksheet Functions | |||
| include INDIRECT function into SUMPRODUCT formula | Excel Worksheet Functions | |||
| INDIRECT Function - what am I doing wrong? | Excel Discussion (Misc queries) | |||
| INDIRECT function question | Excel Worksheet Functions | |||
| Indirect( ) function loosing values when spreadsheets are closed | Excel Worksheet Functions | |||
Threaded Mode
