| 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. |
| 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) | |||
Threaded Mode
