Using VLOOKUP with dynamic filepath for table array
the table array for my vlookup data is based on an external workbook. The filepath of the workbook will change each month. Is there a way to have the table array change to reflect the current month?
This is the formula that works for September:
=VLOOKUP(A12,'[2014-09Data.xlsx]Report'!$A$4:$G$19,3,FALSE)
I would like the table array filepath to change to the following in October:
=VLOOKUP(A12,'[2014-10Data.xlsx]Report'!$A$4:$G$19,3,FALSE)
You could try putting the possible directory names into a data validation list, and have the formula point to that cell for the directory
I have no idea if that would work.
You should hit F5, because chances are I've edited this post at least 5 times.
Example of Array Formulas
Click the * below on any post that helped you.Originally Posted by Jacc
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks