Unanswered: Using variable file names in a vLookup
Does anyone have an example of using a variable file name (and tab) in a vLookup? I have many files with many vLookups that have to be changed every month. It would be wonderful if I could only key the variable name once instead of copying and pasting so many vLookups. I've tried a number of different ways to accomplish this but have been unsuccessful. Please, if anyone has an example that works?
and build the a cell up and them point the INDIRECT to it and it should work
Last edited by myle; 12-04-12 at 04:47.
hope this help
See clear as mud
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Progaming environment: Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010 VB based on my own environment: vb6 sp5 ASP based on my own environment: 5.6 VB-NET based on my own environment started 2007 SQL-2005 based on my own environment started 2008 MYLE YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.
Vlookup from other excel file that has variable name
Guys, I badly need help.
I Need to make vlookup to get information from other excel file that the name varies. actually just a part of a name. I have "file 2016.xlsx" and it will be changed to "file 2017.xlsx"
How to make Vlookup to work with it?
=VLOOKUP(B1,'d:\Data\Approval Numbers\[Approval Numbers Jan "&YEAR(TODAY())&".xlsx]Master'!$1:$1048576,4,0)
this thing works with =hyperlink, unfortunately Vlookup tells me to f*** off.
I can't use macro.
If smoebody finds a way how to do it, please tell me.