1. VLookup Formula for Validation rule will works only in Custom Object... We don't have this VLookup Formula yet in Standard Object Validation Rules...
1. VLookup Formula for Validation rule will works only in Custom Object... We don't have this VLookup Formula yet in Standard Object Validation Rules...
1. VLookup Formula for Validation rule will works only in Custom Object... We don't have this VLookup Formula yet in Standard Object Validation Rules...
https://trailblazer.salesforce.com/ideaView?id=08730000000BqPsAAK
2. If you are going to use this Vlookup Formula in your custom Object Validation rule then you can refer the below one:
3. If you want to prevent duplicate records in satndard object (Account is Standard Object) then go for the Duplicate Rule or Apex Trigger.
Thanks,
Maharajan.C
All Answers
I found the below article which shows how to implement VLOOKUP to prevent duplicates.
http://salesforcevision.blogspot.com/2010/01/search-for-duplicates-validation-rule.html
If this solution helps, Please mark it as best answer.
Thanks,
This is the exact formula which i used for my custom object. It worked for me.
If this solution helps, Please mark it as best answer.
Thanks,
1. VLookup Formula for Validation rule will works only in Custom Object... We don't have this VLookup Formula yet in Standard Object Validation Rules...
https://trailblazer.salesforce.com/ideaView?id=08730000000BqPsAAK
2. If you are going to use this Vlookup Formula in your custom Object Validation rule then you can refer the below one:
3. If you want to prevent duplicate records in satndard object (Account is Standard Object) then go for the Duplicate Rule or Apex Trigger.
Thanks,
Maharajan.C