B
beeblemonster
Hello.
I'm using VLOOKUP to grab data from a different file... that part is pretty
simple. The problem is the file name gets changed a lot. I need to have one
cell that has the path, and somehow get VLOOKUP to reference it's table_array
portion to that cell's path. that way instead of changing the 532 formulas
everytime someone changes the file name I can just change that one cell.
I'm having trouble getting this to work, I think the problem is with telling
it to look at the first tab but i'm not entirely sure.
please help!!!!!
I'm using VLOOKUP to grab data from a different file... that part is pretty
simple. The problem is the file name gets changed a lot. I need to have one
cell that has the path, and somehow get VLOOKUP to reference it's table_array
portion to that cell's path. that way instead of changing the 532 formulas
everytime someone changes the file name I can just change that one cell.
I'm having trouble getting this to work, I think the problem is with telling
it to look at the first tab but i'm not entirely sure.
please help!!!!!