WHich is the best course to attned to learn about 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

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....)