Excel 2007 : refrencing another excel file that changes names daily

[brianbix]

I have a simple vlookup formula refrencing the array from a different excel file on a server, but the name of this file changes daily with the date in the name. can I have my file use a local cell to update the name of the reference file on the server:

For example "Book2.xlsx" would be the server path, but this name changes every morning:
=VLOOKUP(H2,[Book2.xlsx]Sheet1!$A:$B,2,FALSE)

can I do something like this where cell N2 contains the path to the array ([Book2.xlsx]Sheet1!$A:$B) so the formula will update automatically?
=VLOOKUP(H1,N2,2,FALSE)

Or something like this and have just the path (Book2.xlsx) in N2:
=VLOOKUP(H1,"["&N2&"]Sheet1!$A:$B",2,FALSE)

[arlu1201]

You are right on track, but you just missed a small function -

Please Login or Register  to view this content.