Despite being useful and widely used, often, VLOOKUP function in Excel is misused and might result in erroneous output. Common mistakes are not ‘fixing’ lookup range, looking up mismatching data types, and wrong reference to lookup value.
Tables in Excel could be leveraged to overcome these mistakes and can provide more accurate and reliable results.
Watch this video for an example of looking up Region Name to a Country list using Tables in Excel.