VLOOKUPS

The UK's most regular instructor-led training courses.
Training information: excel computer training · Excel training courses · Microsoft Excel Training London
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version 2003

1 post

ReplyThu 4 Feb 2010, 16:17Delegate Andre said...

Andre has attended:
Excel Advanced course

VLOOKUPS

look up between two work books

Version	Date	Location	Places available	Book	Next place rate (£)
Excel VBA Intro Intermediate 2 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2003	Thu 18 + Fri 19 Mar 2010	Southwark	0	FULL
2003	Mon 22 + Tue 23 Mar 2010	Bloomsbury	2		£495	£495
2007	Tue 6 + Wed 7 Apr 2010	Bloomsbury	4		£470	£475
2003	Wed 7 + Thu 8 Apr 2010	Southwark	7		£445	£450
2007	Thu 15 + Fri 16 Apr 2010	Bloomsbury	0	FULL
2003	Wed 21 + Thu 22 Apr 2010	Bloomsbury	8		£445	£450
Full Schedule: See all 36 Excel VBA Intro Intermediate course dates. Bookings currently available until 22nd December 2010.

1,055 posts

ReplyMon 8 Feb 2010, 17:28Trainer Andrew said...

RE: VLOOKUPS

Hi Andre

Thank you for your question. This should work in the same way as using data in the current workbook. So when building your VLOOKUP have your second workbook open. Build the VLOOKUP function and when you get to specify the table_array switch to the workbook containing the data (use the View menu) and select the table of data for the lookup. In the formula bar enter a comma and complete the VLOOKUP statement with TRUE or FALSE as needed followed by a closed bracket.

The lookup should work even if the data source workbook is closed.

I hope this helps - do let us know if you have any further questions.

Kind regards,
Andrew

· Utilise the web's information banks with Microsoft Excel
· 5 Microsoft Excel Charts for Creating Stunning Business Documents
· Interesting Things About Charts In Excel 2003
· Streamlining Excel To Save Time
· Business Forecasting With Microsoft Excel

Please browse our web site to find out more about
excel computer training and other Microsoft training courses.

Excel tip:

Entering text in Multiple Worksheets

If you have a number of worksheets in a workbook that require the same information (data or tables) on each worksheet, this can be done as follows:

Hold down the Ctrl key and click one or more of the additional worksheet tabs (i.e. Sheet2, Sheet3, etc).

In your mainsheet (Sheet1) enter the required data or design a table.

When done 'Click' on the other sheet tabs and you will see that the information entered in Sheet1 is on all the other selected worksheets.

NB Do not forget to deselect the worksheets - otherwise you may add data to the main worksheet and all the selected worksheets will also have that data!

View all Excel hints and tips