microsoft excel training company borough high street london

microsoft excel training company borough high street london - Excel

Resolved · Low Priority · Version Standard

Excel

Jose has attended:
Excel Advanced course

by - delegate Jose [2 posts] (2007 Oct 12 Fri, 14:03) Reply

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?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 3 Wed	Bloomsbury	0	FULL
2003	2008 Dec 5 Fri	Bayswater	1	book now	£195	£205
2002/XP	2008 Dec 10 Wed	Tooting	0	FULL
2003	2008 Dec 10 Wed	Bloomsbury	0	FULL
2007	2008 Dec 10 Wed	Bloomsbury	2	book now	£240	£245
2003	2008 Dec 12 Fri	Southwark	5	book now	£219	£235
Full Schedule: See all 96 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: excel

by - trainer Richard platinum contributer [818 posts] (2007 Oct 17 Wed, 11:47) Reply

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.