VLOOKUP only available in Validation Rules. VLOOKUP can only be done on the Name fields. 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, or URL field type. The field_on_lookup_object must be the Record Name field on a custom object. The field_on_lookup_object and lookup_value must be the same data type.
Hope this helps.
Kindly mark this as solved if the reply was helpful.
VLOOKUP only available in Validation Rules. VLOOKUP can only be done on the Name fields. 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, or URL field type. The field_on_lookup_object must be the Record Name field on a custom object. The field_on_lookup_object and lookup_value must be the same data type.
Hope this helps.
Kindly mark this as solved if the reply was helpful.
Here is a video explanation of how VLOOKUP function works. https://youtu.be/s6qxZ96MZKQ
Some things to remember about the VLOOKUP function 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, text, text area, or URL field type. The field_on_lookup_object must be the Record Name field on a custom object. The field_on_lookup_object and lookup_value must be the same data type. If more than one record matches, the value from the first record is returned. The value returned must be on a custom object. You cannot delete the custom field or custom object referenced in this function. This function is only available in validation rules.
VLOOKUP only available on Custom Objects. Vote for this idea:
- https://success.salesforce.com/ideaView?id=08730000000BqPs
VLOOKUP only available in Validation Rules.VLOOKUP can only be done on the Name fields.
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, or URL field type.
The field_on_lookup_object must be the Record Name field on a custom object.
The field_on_lookup_object and lookup_value must be the same data type.
Hope this helps.
Kindly mark this as solved if the reply was helpful.
Thanks,
Nagendra
All Answers
VLOOKUP only available on Custom Objects. Vote for this idea:
- https://success.salesforce.com/ideaView?id=08730000000BqPs
VLOOKUP only available in Validation Rules.VLOOKUP can only be done on the Name fields.
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, or URL field type.
The field_on_lookup_object must be the Record Name field on a custom object.
The field_on_lookup_object and lookup_value must be the same data type.
Hope this helps.
Kindly mark this as solved if the reply was helpful.
Thanks,
Nagendra
https://youtu.be/s6qxZ96MZKQ
Some things to remember about the VLOOKUP function
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, text, text area, or URL field type.
The field_on_lookup_object must be the Record Name field on a custom object.
The field_on_lookup_object and lookup_value must be the same data type.
If more than one record matches, the value from the first record is returned.
The value returned must be on a custom object.
You cannot delete the custom field or custom object referenced in this function.
This function is only available in validation rules.