Hi

You can use INDIRECT function to return composed range. Like
=INDIRECT("'[" & Sheet1!E3 & "]Approval Summary'!$C$13)

But - INDIRECT works only, when the source workbook is opened at same time.
Otherwise an error is returned.

Arvi Laanemets


"Steve D" <Steve wrote in message
...
Hello, I am trying to create a formula that references another
spreadsheet. I
am able to do this at a manual level but what I am really looking to do is
to
list a number of file names on one sheet and have the formula pull the
file
names from that sheet and insert it into the reference formula. Here is an
example of what I have tried that has not worked:

=IF(ISERROR('[ Sheet1!E3 ]Approval Summary'!$C$13),0,'[ Sheet1!E3
]Approval Summary'!$C$13) + IF(ISERROR('[ Sheet1!E4 ]Approval
Summary'!$C$13),0,'[ Sheet1!E4 ]Approval Summary'!$C$13)

Where Sheet1!E3 would hold something like "abc.xls" If anyone can help
with
this I would greatly appreciate it.

Thank You,
Steve