Excel Vlookup function

Since I use this function every single day at work I thought it would be useful to post here, so that as my memory declines with age, I will always have a good reference for myself.

The vlookup function is used to find a value from the left hand column of a list and return a value from that column or any column to the right of it.

Simple Example (obviously I would do this easy thing without a formula, but I usually deal with 5,000 or more rows and you can see how difficult it would be if the list were longer than 9 rows):
Let's say I have this table and I am looking for the third column given the number 7. I can look in the table and see that that would be the letter "p". The vlookup formula is basically that. Here's how it looks in english: "=vlookup(what you are looking for, where you are looking, what column you want to see, the number zero (don't ask why, just put it there)". In this example the formula would look like this: "=vlookup(7,[the list reference],3,0)". This formula would give me the value "p". If I want the value "g" instead, I just change the ",3," to ",2,". If I want "k", I would change the "(7," to "(2,"

1	a	j
2	b	k
3	c	l
4	d	m
5	e	n
6	f	o
7	g	p
8	h	q
9	i	r

So now you know. Have fun. I'll post something good for the non-technical folks tomorrow.