Kostis;
Studying this a bit further I'd like to better understand the breakdown
of this Indirect() function. It seems that the first normal-looking
part is:

=Indirect(??? B3) << the B3
Next the & in front of the B3 concatenates the mystery part to the B3
with
=Indirect(??? & B3)
Then Everything in the ??? part is within double quotes
=Indirect("???"& B3)
then Only on the right-side end is the ! giving:
=Indirect("??? !"& B3) then the ??? is wrapped in a single quote, like
so:
=Indirect(" '???'!"& B3), then ??? becomes
[????"

At this point I'm getting uncertain of what's going on. Can you assist
me in some way?
Thanks in advance,


"vezerid" wrote in message
oups.com:

Maybe...

=INDIRECT("'["&B1&"]"&B2&"'!"&B3)

HTH
Kostis Vezerides


Jim May wrote:
In Range A1:B3 of WorkBook2.xls I have:
A B
1 From Excel FileName: -- Temp11
2 From Sheet Name: -- Bob
3 From Cell Address: -- A1

In Cell B5

=INDIRECT(B1&$B$2&"!"&B3)

But currently B5 is showing #REF!

Can someone spot my problem?

TIA,