VLOOKUP

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

Resolved · Low Priority · Version Standard

VLOOKUP

Adrian has attended:
Excel Advanced course

by - delegate Adrian [1 post] (2008 Mar 18 Tue, 16:06) Reply

Is it more advisable to use v-lookup rather than h-lookup or they equally as usefull

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2009 Jan 22 Thu + 23 Fri	Southwark	0	FULL
2003	2009 Jan 29 Thu + 30 Fri	Bayswater	4	book now	£475	£485
2007	2009 Feb 5 Thu + 6 Fri	Bloomsbury	5	book now	£485	£490
2003	2009 Feb 19 Thu + 20 Fri	Southwark	4	book now	£475	£485
2003	2009 Feb 26 Thu + 27 Fri	Bayswater	8	book now	£335	£365
2003	2009 Mar 12 Thu + 13 Fri	Bloomsbury	7	book now	£345	£399
Full Schedule: See all 43 Excel VBA course dates. Bookings currently available until 18th March 2010.

RE: VLOOKUP

by - trainer Rich platinum contributer [755 posts] (2008 Mar 20 Thu, 20:51) Reply

v-lookup is a vertical lookup used to find values in a column, h-lookup is a horizontal lookup used to find values in a table/row.

· How to Create Better Excel Spreadsheets: Part Two
· Benefits of learning about Excel charts
· Microsoft Excel Training - Numerical excellence for all
· How to check for and reduce errors in Microsoft Excel
· Fun Things I've Done With Excel

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

Excel tip:

Adjusting the Elevation and Rotation in a 3-D Chart

For any 3-D chart you create, you can adjust the chart’s elevation and rotation to make it more visually appealing. To do this, click the chart and select 3-D View from the Chart menu. The 3-D View dialog box will appear.

The elevation is the height you view the chart from. Click the arrows to the left of the preview picture or enter a value (something between 90 and –90) in the Elevation field to adjust the elevation.

Rotation is the rotation of the plot area around the z-axis. Click the arrows below the preview picture or enter a value (something between 0 and 360) in the Rotation field to adjust the rotation

View all Excel hints and tips

Rate this page: