VLookup Table Array change

  • Thread starter Thread starter Rick
  • Start date Start date
R

Rick

I am creating a spreadsheet for end-users that looks up
the same Look_up value from any one of over 1000 files.
The Look_up value does not change but the table array
changes depending on the file that is being requested
from the end-user. How do I set up the vlookup to adjust
the table array depending on the file being requested? I
do not want the file to open and the end-user does not
know the network path for the file.
An example is the HS1000 can change to one of over 1000
files depending on what file the end-user want the total
for.

=VLOOKUP("Total",'X:\[HS1000.xls]Financial'!
$B$12:$M$42,9,0)
 
I am creating a spreadsheet for end-users that looks up
the same Look_up value from any one of over 1000 files.
The Look_up value does not change but the table array
changes depending on the file that is being requested
from the end-user. How do I set up the vlookup to adjust
the table array depending on the file being requested? I
do not want the file to open and the end-user does not
know the network path for the file.
An example is the HS1000 can change to one of over 1000
files depending on what file the end-user want the total
for.

=VLOOKUP("Total",'X:\[HS1000.xls]Financial'!
$B$12:$M$42,9,0)
Click to expand...

You'll need to use alternative 2 or 3 in

http://www.google.com/[email protected]
 
Back
Top