chronotonFlux
New Member
- Joined
- Dec 18, 2017
- Messages
- 8
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, '[C:\Documents\File1.xls]Sheet1'$A$1:$F$90, 2)
to return a value, is it possible to replace the whole path/array address with a cell reference related lookup?
something along the lines of:
D1 = VLOOKUP(C1, A2 $A$1:$F$90,2)
I am trying to set up command that will read certain information from a file, but the file being read from changes based on a list selection.
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, '[C:\Documents\File1.xls]Sheet1'$A$1:$F$90, 2)
to return a value, is it possible to replace the whole path/array address with a cell reference related lookup?
something along the lines of:
D1 = VLOOKUP(C1, A2 $A$1:$F$90,2)
I am trying to set up command that will read certain information from a file, but the file being read from changes based on a list selection.