Salesforce Advanced Administrator Certification Guide

VLOOKUP

The VLOOKUP function is similar to the Excel function with the same name, and it is used to look up a value inside a specific object's record set.

Let's say we have a custom object that handles all country calling codes.

The object is quite simple:

• Object's name: Call_Prefix__c
• Country's full name: Country_Name__c (custom text field)
• Country's calling code: Name (standard name field)

We want users to manually input the country calling code when creating a new Contact (where we are creating the new validation rule) on the Contact.Phone_Country_Code__c custom field and check that Contact.MailingCountry is equal to the country name found on the Call_Prefix__c object with the same code (on its Name field).

Using VLOOKUP, we can do ...