Remove the brackets from cell A1 and add ".xls" to your
string:

=INDIRECT("'["&A1&".xls]"&B1&"'!"&C1)

HTH
Jason
Atlanta, GA

-----Original Message-----
I need to use an Indirect to another wookboot that has a
multi-word name ie
'expense report' not something like 'er' in my excel I
did the following to
test
a1 = [expense report]
b1 = sheet1
c1 = a2
d1 = indirect(a1&b1&"!"&c1)

if I use a name in a1 with no spaces ie 'er' then the
indirect works but if
I use the above example I always get #ref error in
cell. Anyone got any
ideas?

I also did try d1 = indirect("'"&a1&b1&"'!"&c1). It
didn't work either.


.