Hi everyone,

I have seen many posts on a similar subject and I have tried to adapt posted solutions to my formulae to suit without any success. Basically, i have a cell L3 on a worksheet which contains a worksheet name from within a different file called Bristol & Taunton Book List All Freqs.xlsx. When I use this formulae below, it returns the data as expected without a problem. the worksheet name in this instance is 16 and both files are open.

=INDEX('[Bristol & Taunton Book List All Freqs.xlsx]16 '!$B:$B,MATCH(C8,'[Bristol & Taunton Book List All Freqs.xlsx]16 '!$D:$D,0))

When I try to incorporate INDIRECT in to the formulae as shown below, the REF error is displayed

=INDEX(INDIRECT("'[Bristol & Taunton Book List All Freqs.xlsx]"&$L$3&" '!$B:$B"),MATCH(C8,INDIRECT("'[Bristol & Taunton Book List All Freqs.xlsx]"&$L$3&" '!$D:$D,0")))

Am I trying to do something that is not possible?

Any help that you can give would be greatly appreciated.

many thanks,

Stan