-
How to implement VLookup in Salesforce formulas?
How to implement VLookup in Salesforce formulas?
-
3 Replies
-
It searches an object for a record where specified field matches the specified lookup value. If a match is found, returns another specified value.
syntax of vlookup:
VLOOKUP(field_to_return, field_on_lookup_object, lookup_value)
-
VLOOKUP(field_to_return, field_on_lookup_object, lookup_value)
Searches an object for a record where the specified field matches the specified lookup_value. If a match is found, returns another specified field value.
-
Hi,
Try this -
VLOOKUP(field1, lookup, value)
Hope this helps.
Log In to reply.
Popular Salesforce Blogs
Use of Database.Statefull in Batch Apex when aggregating values for large data
We often came across situations in apex where we are required to calculate aggregate data but we have a limitation of 50000 records at a…
Boost productivity with the Salesforce Inspector Chrome Extension
With digitization, the workload in every organization is growing exponentially, creating a lot of mundane, but essential tasks. These activities are time-consuming and not so…
How to Make Communities Faster? What are the Required Tools for This?
As businesses and organizations expand, the need to manage and maintain multiple systems becomes increasingly necessary. Often, data needs to be shared across systems, and…
Popular Salesforce Videos
Salesforce Essentials
Watch this video to learn what customer relationship management (CRM) is and how CRM helps companies better engage with prospects and customers, streamline communications, and…
How to Take Your Salesforce Support Model to the Next Level
Jeremy Muldoon, the Salesforce expert at Rimini Street, discusses the Salesforce resource challenges faced by businesses today, how to overcome them, and how to take…
Custom Button URL Hacking in Salesforce Lightning Experience vs Salesforce Classic
Custom Button URL Hacking in Salesforce Lightning Experience vs Salesforce Classic Custom button URL Hacking approach in Salesforce Classic Custom button URL Hacking approach in…
