Stop using vlookup. Use index and match, either through named references as Joel does it or just manually even. It's more powerful, faster and less prone to failure because vlookup relies on an assumed order of sorting but most people won't know this and will wonder why it's cocking up.
The second most important thing is how to use vlookup() for cross-sheet lookups, using a column in the other sheet as a foreign key.