I'm trying to use the value of a cell to determine which file to open within a folder.
So here's the list of files that i'm trying to reference:
[Blocked Image: http://i.imgur.com/w0w75qH.png]
Im trying to use the value of the top cell to Determine which file to pull the data from.
When i try the following Formula:
[Blocked Image: http://i.imgur.com/eNl6hp5.png]
It just keeps opening the dialog box for me to select where the file is again.
I hope it makes sense what I'm trying to do/explain