I'm trying to write a formula that will allow me to reference external spreadsheets and which contains a reference to a cell within the current spreadsheet.
This is how the current reference looks:
='C:\Users\camb\Desktop\Project Tracking\[PT 040519.xlsx]Overview'!$G$2
I want to replace the "PT 040519" with a reference to cell A2. I've tried a concatenate formula but I keep getting an error.
Does anyone have any suggestions on how to accomplish this?
This is how the current reference looks:
='C:\Users\camb\Desktop\Project Tracking\[PT 040519.xlsx]Overview'!$G$2
I want to replace the "PT 040519" with a reference to cell A2. I've tried a concatenate formula but I keep getting an error.
Does anyone have any suggestions on how to accomplish this?