Returns a value by
looking up a related value on a custom object similar to the VLOOKUP() Excel
function
1.
VLOOKUP only available on Custom Objects.
2.
VLOOKUP only available in Validation Rules.
3.
VLOOKUP can only be done on the Name fields.
4.
The field_to_return must
be an auto number, roll-up summary, lookup
relationship, master-detail relationship, checkbox, date, date/time, email, number, percent, phone, picklist, text, text
area, orURL field type.
5.
The field_on_lookup_object must
be the Record Name field on a custom object.
6.
The field_on_lookup_object and lookup_value must
be the same data type.
7.
If more than one record
matches, the value from the first record is returned.
8.
The value returned must
be on a custom object.
9.
You cannot delete the
custom field or custom object referenced in this function.
E.g.
A simple validation on a
Custom Object Invoice__c.
Here vlookup function
matches invoice name to value ‘krrish’ if found duplicate then it returns
testValues_c field value of first
matches record.
Name=VLOOKUP(
$ObjectType.krrish__Invoice__c.Fields.krrish__testValues__c,
$ObjectType.krrish__Invoice__c.Fields.Name,"krrish" )