Use 2 cells, say A1:B1, to house the book name and tab name, eg:

In A1: GOODYEAR
In B1: GT_0

Then with GOODYEAR.xls simultaneously open, use:
=INDEX(INDIRECT("'["&A1&".xls]"&B1&"'!L1:N98"),MATCH($A6,INDIRECT("'["&A1&".xls]"&B1&"'!L1:L98"),),MATCH("BUY",INDIRECT("'["&A1&".xls]"&B1&"'!L1:N1"),))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"timmulla" wrote:
Can anyone help me substitute an indirect function for the Workbook and tab
name in the following formula. I want my formula to use cell A1 to determine
the workbook and tab to pull data from.


=INDEX([GOODYEAR.xls]GT_0!$L$1:$N$98,
MATCH($A6,[GOODYEAR.xls]GT_0!$L$1:$L$98,),
MATCH("BUY",[GOODYEAR.xls]GT_0!$L$1:$N$1,))

Any help would be appreciated

--
Regards,

timmulla