Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Vlookup - name of file to get info from is in Column A
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I recover a file, with info, that I did'nt Save? | Excel Worksheet Functions | |||
How do I use vlookup to point to an external file that changes nam | Excel Worksheet Functions | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
VLOOKUP from a file on another server | Excel Worksheet Functions | |||
File asks to update when no links were created | Links and Linking in Excel |