VLookup Function in SFDC

There are some of the functions which can not be used with formula fields and one such function is vlookup.

This function is only used in the validation rules.

Vlookup works exactly the same way the Lookup function works in excel and helps in maintaining the integrity of your data.

Business Use Case: We want to make sure, the discount entered is as per the master table shared by the organization based on n variables.