I use VLOOKUP quite a lot, but it's far from perfect and I suspect if I looked into it there is a better way. The problem is that if there is no exact match in the reference table, VLOOKUP will return the results for the entry directly below. So the returned results aren't necessarily accurate.
It's basically a hangover from the Lotus 123 days anyway. Avoid if possible.