On 2002-05-22 10:31, Lt. Krul wrote:
I'd like to do a vlookup from a closed workbook. can this be done. I don't want my users to have to open the other workbook everytime they use the vlookup function.
On 2002-05-22 11:02, Lt. Krul wrote:
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)