Usually when I use VLOOKUP, I want to pull information for an exact match. For example, if I enter a customer number in one cell, I want the customer name in the adjacent cell. I don't want the name of a customer whose number is CLOSE to the one that I entered.

In some situations [...]