Why did your formula references change from your original post? <g

Try this:

=INDEX(INDIRECT("'[x.xls]"&G12&"'!$A$1:$C$60"),MATCH("Discussion Questions -
week
3",INDIRECT("'[x.xls]"&G12&"'!$A$1:$A$60"),0),MATCH("(EDTC/560-MABJ01IJF3)",INDIRECT("'[x.xls]"&G12&"'!$A$1:$C$1"),0))

As soon as file x.xls is closed and the file that contains this formula
calculates, the formula will return #REF!.

Biff

"elrussell" wrote
in message ...

Biff - thanks for the response. Yes, both files are open and in the same
folder. The file (x.xls) that I am trying to read "from" was opened
first.

Here is my latest "try" - it might explain better my efforts...

=INDEX("'[x.xls]"&G12&"'!"&$A$1:$C$60, MATCH("Discussion Questions -
week 3","'[x.xls]"&G12&"'!"&$A$1:$A$60,0),
MATCH("(EDTC/560-MABJ01IJF3)","'[x.xls]"&G12&"'!"&$A$1:$C$1,0))

the cell G12 contains BradfordBowen

I am getting a #VALUE error

Thanks again!


--
elrussell
------------------------------------------------------------------------
elrussell's Profile:
http://www.excelforum.com/member.php...o&userid=31020
View this thread: http://www.excelforum.com/showthread...hreadid=506894