Putting Directory of a workbook in Cell and Referencing The workbook

[Rogue909]

I want to be able to insert the directory of a workbook in a cell and then be able to reference that workbook to do an index search of the workbook.

IE;
Cell A1; C:.....Desktop/MyExcel.xlsx

Let's say cell B1 has a value of 42.... I want cell B2 to index\match search Column A of MyExcel.xlsx to find a particular data point.


This may confuse things further.. but my current cells look like this

A3='C:\Reports\Daily Calibration\Daily Calibration.xlsx'

F11=INDEX([A3]A3!D2:D15000,MATCH($C$11&$D$11&$E$11,'[A3]Current Year'!$A$2:$A$15000&'[A3]Current Year'!$B$2:$B$15000&'[A3]Current Year'!$C$2:$C$15000,0)+COUNT(IF('[A3]Current Year'!$A$2:$A$15000=$C$11,1))-1)

Cell A3 has a directory to our daily calibration file. While filling out reports I want the index match to make sure that three criterias are met (C11, D11, and E11) find the corresponding data (in this case D2:15000 of Daily Calibration.xlsx) and use the most recent entry.