I really recommend Chandoo (http://chandoo.org/wp/
) if you're looking to prepare. When I was teaching myself Excel instead of actually working, I used to log in there every day at work and I think what I read there did more to prepare me than anywhere else.
Nowadays, though, I just Google my questions since someone else has probably had the EXACT same problem. That works pretty well for when you're actually working and just run into a problem.
I use VLookup 5 days a week and I am pretty good in Excel overall, so if you need help just holler over FB or something.
Remember that VLookup is like Zoolander, it can't turn left, so make sure your common value is to the left of whatever column you are pulling from. Also, the Trim function is the #1 problem solver when a VLookup returns the dreaded #N/A.
Shit, not only am I a nerd, but I'm a nerd in the least exciting program ever.
Sarlacc, on comparing .NET to Soccer: And why not? It's a bunch of people running around in circles, feigning pain, and never scoring.