VLOOKUP is a useful function but can be hard to get right. Here's how to use Excel VLOOKUP and what to do when it doesn't work the way it should.
