Both of these are quite different from an approximate match or a fuzzy lookup. However, the VLOOKUP function, similar to Excel’s other lookup functions such as HLOOKUP and MATCH, is built to perform an exact match or a range lookup. The VLOOKUP function alone has saved countless hours in my recurring use workbooks. When implemented in the right way for special projects or in recurring use workbooks, they are able to save a ton of time. The built-in Excel lookup functions, such as VLOOKUP, are amazing. This post explores Excel’s lookup functions, approximate matches, fuzzy lookups, and exact matches.
