Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
File name from cell
=VLOOKUP(C$2,[Malcolm.xls]Login!$M$1:$N$31,2,FALSE)
in the above formula, how to make the file pick from cell? Something like &A3&".xls"? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
File name from cell
Try
=VLOOKUP(C$2,INDIRECT("'[" & A3 & ".xls]Login'!$M$1:$N$31"),2,FALSE) If this post helps click Yes --------------- Jacob Skaria "Kash" wrote: =VLOOKUP(C$2,[Malcolm.xls]Login!$M$1:$N$31,2,FALSE) in the above formula, how to make the file pick from cell? Something like &A3&".xls"? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
File name from cell
But for INDIRECT, other file should be open right? But, how to go if file is
closed? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
File name from cell
You can download an add-in called Morefunc it has a function called
INDIRECT.EXT which will work if the source book is closed Refer http://xcell05.free.fr/morefunc/english/index.htm If this post helps click Yes --------------- Jacob Skaria "Kash" wrote: But for INDIRECT, other file should be open right? But, how to go if file is closed? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
File name from cell
Hi,
When I use the indirect.ext function it works fine until I recalculate the workbook. When I do so, it shows an error value -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Jacob Skaria" wrote in message ... You can download an add-in called Morefunc it has a function called INDIRECT.EXT which will work if the source book is closed Refer http://xcell05.free.fr/morefunc/english/index.htm If this post helps click Yes --------------- Jacob Skaria "Kash" wrote: But for INDIRECT, other file should be open right? But, how to go if file is closed? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking to another file using file reference typed cell | Excel Worksheet Functions | |||
Autoname a save as file from a cell in a read only file | Excel Discussion (Misc queries) | |||
Is it possible to link cell formatting in Excel from file to file | Excel Discussion (Misc queries) | |||
when inserting a file name in a cell how do you remove file type | Excel Worksheet Functions | |||
Saving worksheet in new file with date AND cell value as file name | Excel Discussion (Misc queries) |