Adding a file path into a formula that is typed into a another cell
- by Adam Graham
I have
'C:\Users\Documents...etc.......[file name.xlsx]Work Sheet'!$B:$F
in cell B1
i then want to run a vlookup formula to the above file but instead of
vlookup(A1,'C:\Users\Documents...etc.......[file name.xlsx]Work Sheet'!$B:$F,2,false)
I want to use the cell B1 for the path.
Reason is i want the master to look at multiple workbooks and i don't have time to sit and retype.
Please help