training excel vba - 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