You can sacrifice a little speed for an exact match. VLOOKUP's fourth parameter defines whether the list is sorted. If the parameter is TRUE (the default) it will return a value every time, if your desired entry isn't in the list you will get a return which is the closest. If you set the parameter to FALSE you don't need to sort the list but you will get an error message if it cannot find your value.