Fri 12 Oct 2007, 14:03Delegate Jose said...
Jose has attended:
Excel Advanced course
Excel
Vlookups - How are they run if you are looking from different Workbooks?
Do both workbooks need to kept updated?
Can you Vlookup in multiple workbooks?
Wed 17 Oct 2007, 11:47Trainer Richard said...
RE: excel
You would need to enter the Workbook location, sheet name, and cell range when refering to the Array you want to search in.
ie.
=VLOOKUP(A1,[file.xls]Sheet1!$A$1:$B$21,2,FALSE)
[file.xls]sheetname!cellref:cellref
Yes you would need to update both sheets.
No, you can only lookup on Array at a time.
