Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » training excel vba - V Look Ups

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

training excel vba - V Look Ups

Resolved · Low Priority · Version Standard

Reply Thu 20 Sep 2007, 16:35Delegate Natascha said...

Natascha has attended:
Excel Intermediate course
Powerpoint Intermediate Advanced course

V Look Ups

WHich is the best course to attned to learn about V Look ups ?

For upcoming training course dates see: Pricing & availability

Reply Fri 21 Sep 2007, 15:36Delegate Paul said...

RE: V Look Ups

There are many resources on the web for vlookup

simply though, a vlookup searches in a named range and returns the value in the specified column of the range

Say you have a list of people in sheet2, column A is the person's user number. Column B is their first name, column C is their surname and column D is their favourite colour.

1 James King Brown
2 Peter Smith Pink
3 Ryan Jones Yellow
4 Jill McLeish Green
5 Laura Chivers Red

lets say you want to type in the persons user number and get excel to return their favourite colour in the cell next to it.

in sheet1 Cell A2 type '=vlookup(A1,Sheet2!A:D,4,0)' (without the speech marks of course) and press enter

now, when you type a number into cell A1 on sheet 1 and press enter, cell A2 on sheet 1 will change to the favourite colour of that person

the vlookup formula is explained like this:

=vlookup(cell with the related data, range to look in, the number column you want to return data from,look for exact matches only)

hope this helps.

Paul

Reply Thu 18 Oct 2007, 09:48Trainer Rajeev said...

RE: V Look Ups

Dear Natacha

The best course to be on for VLookUP is Excel Advanced!! You can book for 2002, 2003 or even 2007 if you want!!

Please go to the following link to see when is the next Excel Intermediate course is scheduled:

http://www.microsofttraining.net/order/pricing_availability.php

just copy and paste this in whichever browser you use i.e. Internet explorer, Mozilla FireFox, Netscape Navigator, etc....)

Excel articles

· Microsoft Excel Cheat Sheet: Tips and Shortcuts
· Tips for Transitioning to Excel 2007
· From novice to expert users - Microsoft Excel fits all
· Chart Creation Simplified - in 4 Simple Steps
· Create A Basic Timeline In Excel

Excel tip:

Using the Quick Access Toolbar in Excel2010

The Quick Access Toolbar is included in virtually every Office product, including Outlook 2010, Word 2010, Excel 2010, and PowerPoint 2010.

You will find the Quick Access Toolbar in the top-left side of the window. To begin, click the Customize button (it's the little black arrow at the end of the toolbar).

Simply click the commands you want to include.

Virtually any command can be added to the Quick Access Toolbar. Click the More Commands option and a new window will open from where you can browse the commands including those not on the ribbon.

View all Excel hints and tips