Can any one explain the functionality of VLookup in salesforce with good example..
1 answer
Hi Arunkumar:
When used in conjunction with validation rules, the VLOOKUP function can enforce data consistency by comparing data input on one object with a predefined set of records in a 'lookup' object. For example, a technology company may have a list of products of SKUs in a master table. That table may be loaded as a matrix into a custom object called: "Product Master." On an opportunity page, when sales reps are entering product information, a validation rule with a VLOOKUP function will ensure the proper data entry combination is entered for the Product name and SKU. An example used in class is ensuring the Zip Code entered on a contact record, is consistently with Zip Code and State combinations from the USPS. If I enter 90210 for a Zip Code and Massachusetts for the state, the validation rule will look at a Zip Code matrix object and see if the 90210/MA combination exists. If it doesn't, the validation rule will fire an error message. Let me know if this explaination helps.
