Skip to main content
Topics#CRM ConfigurationJagriti Kukreti's Question
Jagriti Kukreti (RBC) asked in #CRM Configuration
Jan 4, 2019, 3:46 AM

Can we use vlookup in formula field?

2 answers
  1. Nagendra Babu Pilli (Salesforce)
    Jan 4, 2019, 3:58 AM
    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
Write an answer...
0/9000