Vlookup with reference to external file

  • Thread starter Thread starter Anne Coles
  • Start date Start date
A

Anne Coles

Please tell me if this is even possible.

I have a master spreadsheet with a list of values based by
person. Each person has their own separate spreadsheet
with a paste link that keeps their info current from the
master. Some info they input in their sheet needs to be
fed back to the master. Each person's spreadsheet's file
name is their name, like anne.xls.

In the master sheet, I have an if formula that returns the
correct filename based on the column of personnel name. I
want to do a vlookup field that returns to their sheet to
populate the cell but I don't know what context to use.

Any ideas? Thanks in advance.
 
Yes that is possible

=VLOOKUP(A4,'C:\Documents and Settings\AColes\My Documents\Excel
Files\[Anne.xls]Sheet1!$A$2:$B$30,2,0)

as an example. When you first create it , it helps if the other files are
open since you can select
them using the mouse and get the path for free when you close them later, it
will however work
with closed files..
 
Thanks Peo...
It still is not doing what i want. The file name changes
by person, how do I reference it in the actual formula? I
am getting a REF# error.
-----Original Message-----
Yes that is possible

=VLOOKUP(A4,'C:\Documents and Settings\AColes\My Documents\Excel
Files\[Anne.xls]Sheet1!$A$2:$B$30,2,0)

as an example. When you first create it , it helps if the other files are
open since you can select
them using the mouse and get the path for free when you close them later, it
will however work
with closed files..

--

Regards,

Peo Sjoblom


Anne Coles said:
Please tell me if this is even possible.

I have a master spreadsheet with a list of values based by
person. Each person has their own separate spreadsheet
with a paste link that keeps their info current from the
master. Some info they input in their sheet needs to be
fed back to the master. Each person's spreadsheet's file
name is their name, like anne.xls.

In the master sheet, I have an if formula that returns the
correct filename based on the column of personnel name. I
want to do a vlookup field that returns to their sheet to
populate the cell but I don't know what context to use.

Any ideas? Thanks in advance.
Click to expand...


.
Click to expand...
 
Back
Top