What is the benefit of Vlookup in salesforce?

They give us a major clue into what the developers had in mind when they created this in Salesforce. In short, VLOOKUP is built to let you validate data against a known list of values. It helps ensure that two fields on your record have compatible data