excel formula

i have a column (A) that lists numbers. these numbers are not constant.
these numbers represent the file name in another directory. i would like to
write a formula in column b that represent the file name and an address in
that file name. for example B7. an example follows:

A B

60007 file in column A1 "60007" , at range B7
60045 File in column A2 "60045" , at range B7

Please advise if any other info is required?

thanks
--

Hi
if these other files are NOT closed you can use the build-in function
INDIRECT. e.g.
=INDIRECT("'[" & A1 & "]sheet1'!B7")

if the files are closed see:http://tinyurl.com/2c62u for some
alternatives. In your case INDIRECT.EXT should work. use a formula like

=INDIRECT.EXT("'C:\temp\[" & A1 & "]sheet1'!B7")



--
Regards
Frank Kabel
Frankfurt, Germany


dd wrote:
i have a column (A) that lists numbers. these numbers are not
constant. these numbers represent the file name in another directory.
i would like to write a formula in column b that represent the file
name and an address in that file name. for example B7. an example
follows:

A B

60007 file in column A1 "60007" , at range B7
60045 File in column A2 "60045" , at range B7

Please advise if any other info is required?

thanks