Hi!

A couple of things:

datajoe.xls!N6

You don't specify the sheet name.
The reference to C2 doesn't work because C2 is a formula
that returns the value datajoe.xls!N6.
Using Indirect requires that the other WB be opened.

Try this:

=INDIRECT("[data"&B2&".xls]sheet1!N6")

Replace sheet1 with the appropriate sheet name.

Biff

-----Original Message-----
Any help is appreciated... really stuck on this.
I am trying to reference an external cell where the file
name
changes/corresponds to a particular local cell value.

For example:
Column B= Username.
Cell B2 = [JOE].

I want to get the data from cell N6 in the excel
spreadsheet named
c:\data[joe].xls

I want to use a formula that uses the username in the
cell reference... In
the above example, I'm trying something like
=data'B2'.xls!N6

to try and get
=dataJOE.xls!N6.

I'm also trying INDIRECT() function...
in C2 ="data"&B2&".xls!N6" which returns "datajoe.xls!N6"
then in D2 I use =Indirect(C2)
but can't get D2 to actually return the value for
=dataJOE.xls!N6

Thanks
B
_________________
An idea is salvation by imagination.
- Frank Lloyd Wright

.