Dear All,
Iam just thinking some kind of automation in vlookup so lets try to do this.
This is my formula: =VLOOKUP(A4,'Z:\Data\Extra\Check\[Jan'09.xlsx]Sheet1'!$A$2:$B$2,2,FALSE)
This is true code but if i like to do automation means i have month values in the drop down list like Jan'09, Feb'09, Mar'09 etc.
and if iam changing the values of months than automaticall the formula should pull the value from the repective month file.
if any 1 have idea for the same please let me know...
Hello ashish,
welcome to the forum.
Whereas Vlookup works on closed workbooks, you would need to involve INDIRECT() to string together your formula with varying filenames. INDIRECT, unfortunately does not work on closed workbooks, so you'll either need to make sure the workbook is open when the INDIRECT is performed, or you can resort to the morefunc.xll, wich has a formula INDIRECT.EXT, that also works on closed files.
Explore morefunc.xll here : http://xcell05.free.fr/morefunc/english/index.htm
If an open workbook can be assumed, your formula could be constructed like this:
=VLOOKUP(A4,INDIRECT("'Z:\Data\Extra\Check\["&A1&"]Sheet1'!$A$2:$B$2"),2,FALSE)
where A1 has the name of the workbook you want to reference.
hth
teylyn
Microsoft MVP - Excel
At Excelforum, you can say "Thank you!" by clicking theicon below the post.
Avoid pie charts with more than two data points. Why? See here (pdf, 559 kb). The only acceptable pie chart is here.
Hi,
This doesn't appear to be an Access question, so would one of the Mods please move this thread to an Excel forum?
Thanks,
Docendo discimus.
Please consider:
- Thanking those who helped you. Click the reputation icon
in the contributor's post and add Reputation.
- Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks