can i reference a file location in a separate cell for vlookup? i have a
whole column of numbers that come from different files, but they tend to move
around to different folders quite a bit. plus, if it works, i'd like to use
it as a template. however, i don't want to have to change every cell's
lookup. if i could just have the file location and name in a cell somewhere
and change that one spot instead of individual formulas, it'd be great. it
seems like something that should be so easy!