Skip to main content
Topics#CRM ConfigurationQuestion de Jagriti Kukreti
Jagriti Kukreti (RBC) a posé une question dans #CRM Configuration
4 janv. 2019, 03:46

Can we use vlookup in formula field?

2 réponses
  1. Nagendra Babu Pilli (Salesforce)
    4 janv. 2019, 03:58
    Hi,

    VLOOKUP only available on Custom Objects. Vote for this idea: 

    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
Rédiger une réponse...
0/9000