How To Use VLookup Function in Excel

I hate excel. It has to be said. However we use excel everyday for everything, simple calculations, records of rankings, doing keyword research etc. One of the things that I had to do this week is compare monthly search volume on certain keywords and plot it against current rankings into a graph.
Sounds easy, and it IS easy and there are resources like Rich Baxter’s tutorial that shows you how to do it - but I just wasn’t following half way. :( It is no doubt an awesome tutorial that probably took ages to do and I appreciate that - this post on the other hand, is kinda like an extension of that post, if you will, but for really slow folks like me who need to go through every single step slowly, understand it and then have screenshots in front of my face for every click.