try this =INDIRECT("[Name"&A1&"]Sheet!A1")
the NameNN file must be open
If you want to work with closed files Laurent Longre has an addin
(morefunc.xll) at:
http://xcell05.free.fr/
That includes =indirect.ext() that may help you.
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

wrote in message
ups.com...
Hello All

I am looking for a way to create a reference in my first document that
will be able to call to a variable document depending on a value in a
set cell.

So if the cell in document A is 10 then it will know to call document
name10.xls and if the value is 11 then it will call document
name11.xls...


Anyone have any ideas how this can be done?


Thanks!