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