VLookup problem

[berty2000]

work book 1 data base
work book 2 Schedule
work book 3 Master file

In workbook 1 lots of VLookups used pulling data from workbook 2 Schedule, looks like this:

=VLOOKUP $J$21,'T:\SCHEDULE\[MOULDINGS_Current_month_schedule11.xls]403'!$E$8:$H$100,2,FALSE)

In workbook 3 I want to make it a master file so every time the schedule changes month or location I only have to change this one file name and all the formula will still work e.g

workbook 3
A1 File Location
B1 T:\SCHEDULE\[MOULDINGS_Current_month_schedule11.xls


Tried
=VLOOKUP $J$21,'[Book3]Sheet1!$B$1]403'!$E$8:$H$100,2,FALSE)

does not work any one got any ideas

Cheers for now

 

[JackDanIce]

You need to use the INDIRECT function I think.

E.g
If in cell A1 you have the value "Jaffa cakes",
In cell A2 the value "A1", then

=INDIRECT(A2)

Returns the value "Jaffa cakes"