How wold I go about implementing a VLOOKUP that takes it's array range from a cell value?
For Example.
A1 = Sheet1
B1 = '[C:\Documents\File1.xls]Sheet1'
A2 = Sheet 2
B2 = '[C:\Documents\File1.xls]Sheet2'
A3 = Sheet 3
B3 = '[C:\Documents\File1.xls]Sheet3'
Instead of hardcoding:
D1 =VLOOKUP(C1...