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
Bookmarks