In Excel, we can look up values by using different functions and logical comparisons. But most of the time these functions require an exact match and ...