I have a column with the folder name, a column with the filename and a column which creates the entire path to the data I want which is:

'/Users/darren/Desktop/3401/[CAR Master.xlsx]Master'!$C$4

If I use a cell containing:

='/Users/darren/Desktop/3401/[CAR Master.xlsx]Master'!$C$4

then it reads the location C4 from tab Master in the excel spreadsheet "CAR Master.xlsx" in folder "/Users/darren/Desktop/3401" and I get the correct value.

However if I use

=INDIRECT(C3) I get #ref I have also tried =INDIRECT(C3,false) but still get #ref.

Any ideas?