Automate VLOOKUP without limitations
Excel cross referencing is usually done with VLOOKUP. It certainly is a useful tool, but users are also confronted with the limitations when they want to automate VLOOKUP in Excel:
- The function does not recognize synonyms or abbreviations.
- VLOOKUP can’t deal with small mistakes in product numbers, for example: if you VLOOKUP product number 4015-0800/ and in your database it is correctly stored as 40150800 VLOOKUP won’t be able to cross reference this product number.
- VLOOKUP does not have the ability to give alternative or similar options, for example if you are looking for a certain product with certain attributes VLOOKUP is not ‘’smart’’ since it does not use advanced algorithms or machine learning. It is not able to give you recommendations based on the information you put in.
- Often you will deal with the #NA error in VLOOKUP. In big data sets it is very hard to identify the leading or trailing spaces in lookup values that cause the VLOOKUP function to not find the match and return #NA error.