Hi!

There is a way but it requires that the target file be open. That's a huge
disadvantage!

Still interested?

Biff

"DD1" wrote in message
...

I have a file with data in Column A only. For example, cell A1 contains
the word "Pathology", A2 contains the word "Pharmacy" etc. These names
are actual filenames. So I have a file called Pathology.xls and one
called Pharmacy.xls. I would like to write a vlookup to extract
information from these files, and put this information in Column B.

Is it possible to write a Vlookup which can be dragged down, so the
name of the file that it goes to get the information from is linked
directly to the name in Column A?

Within the Vlookup function - it's the second part of the formula,
after the first comma, that I want to link to Column A

I hope that makes sense.
Regards,
David


--
DD1
------------------------------------------------------------------------
DD1's Profile:
http://www.excelforum.com/member.php...o&userid=25169
View this thread: http://www.excelforum.com/showthread...hreadid=394829