| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I pull in the filename used in Vlookup from another cell?
I'm trying to link from 26 separate but identically formatted files to pull
in similar data. I want to use a single formula, but swap out the filename based on the value I put into another cell. Anyone ever done that? I keep trying but can't get past the formula error checker... I was working with 26 different formulas but need this flexibility to adjust to the amount of data I need to collect from each file. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can I pull in the filename used in Vlookup from another cell?
You can use INDIRECT but it only works if the other file is open.
Otherwise you would need to download and install an add-in like Morefunc http://xcell05.free.fr/morefunc/english/#Download look at indirect.ext -- Regards, Peo Sjoblom "frustrated linker" <frustrated wrote in message ... I'm trying to link from 26 separate but identically formatted files to pull in similar data. I want to use a single formula, but swap out the filename based on the value I put into another cell. Anyone ever done that? I keep trying but can't get past the formula error checker... I was working with 26 different formulas but need this flexibility to adjust to the amount of data I need to collect from each file. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLookup / pull data from 1 sheet to another | Excel Discussion (Misc queries) | |||
| Cell("filename") doesn't update to new filename when do save as. | Excel Worksheet Functions | |||
| Vlookup Cell Contents Filename | Excel Worksheet Functions | |||
| CELL("filename") acting Volatile? (in assoc. with PULL) | Excel Worksheet Functions | |||
| vlookup and filename returning same result on each sheet. | Excel Discussion (Misc queries) | |||
Linear Mode
