-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Vlookup from a closed workbook?
- Thread starter Lt. Krul
- Start date
Aladin Akyurek
MrExcel MVP
- Joined
- Feb 14, 2002
- Messages
- 85,210
Yes, as long as you don't throw in the formula something like INDIRECT.
Upvote
0
OK - heres what I have:
workbook A contains cells that have the Vlookup function applied
the function is =VLOOKUP(A16,ProjectName,2,0)
where: A16 is the lookup value
ProjectName is the named Range
2 is the Column I'm interested in
0 is the Range lookup value
ProjectName is defined as: ='[workbook b]sheet1'!$A$2:$E$8000
So far the vlookup only works when Workbook B is open. Any Ideas...(I'm not so good at this programming stuff yet)
workbook A contains cells that have the Vlookup function applied
the function is =VLOOKUP(A16,ProjectName,2,0)
where: A16 is the lookup value
ProjectName is the named Range
2 is the Column I'm interested in
0 is the Range lookup value
ProjectName is defined as: ='[workbook b]sheet1'!$A$2:$E$8000
So far the vlookup only works when Workbook B is open. Any Ideas...(I'm not so good at this programming stuff yet)
Upvote
0
Oops...let me clarify something from my past post...
The Cell A14 is attempting to Apply data validation from data in that closed workbook B. The Vlookup reads the value from A14 and attempts to return a value from column C in that same workbook B.
Does that confuse the issue :wink:
I suppose my question now is: can I perform Data validation from a closed workbook?
Thanks.
The Cell A14 is attempting to Apply data validation from data in that closed workbook B. The Vlookup reads the value from A14 and attempts to return a value from column C in that same workbook B.
Does that confuse the issue :wink:
I suppose my question now is: can I perform Data validation from a closed workbook?
Thanks.
Upvote
0
Aladin Akyurek
MrExcel MVP
- Joined
- Feb 14, 2002
- Messages
- 85,210
Go to the workbook b, select A2:E8000, go to the Name Box on the Formula Bar, type PROJECTS (a better name, no?), hit enter.
=VLOOKUP(A16,ProjectName,2,0)
becomes something like
=VLOOKUP(A16,'C:.........workbook b.xls'!PROJECTS,2,0)
Upvote
0
Dave Patton
Well-known Member
- Joined
- Feb 15, 2002
- Messages
- 6,342
- Office Version
- 365
- 2010
- Platform
- Windows
try creating the formula again with reference to the named formula in the other ss.
- name the formula in the other ss or reference the relevant range.
=VLOOKUP(A16,Workbookb.xls!ProjectName,2,0)
This formula shows the full path when the other SS is closed.
=VLOOKUP(A16,'E:data02Tech02Workbookb.xls'!ProjectName,2,0)
The path will be different on your system.
- name the formula in the other ss or reference the relevant range.
=VLOOKUP(A16,Workbookb.xls!ProjectName,2,0)
This formula shows the full path when the other SS is closed.
=VLOOKUP(A16,'E:data02Tech02Workbookb.xls'!ProjectName,2,0)
The path will be different on your system.
Upvote
0
Similar threads
- Question
- Question
