function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Somasundaram S 1Somasundaram S 1 

vlookup fucntion for validation

HI All
         I have a test field in my system , is it possible to use vlookup to avoid duplicate entry for this text field. Please advise.
thanks
ss
 
Amit Chaudhary 8Amit Chaudhary 8
Please check below post for Vlookup
1) http://focusonforce.com/configuration/salesforce-vlookup-example/

User-added image

I dont think so you can control the duplicate value check by Vlookup. Vlookup is same like Excel function you can check the value only.
$ Maddy  $$ Maddy $
I am not sure about vlooup but you can make this field as Unique (no duplicate values). Then create a Workflow Rule that passes the values to your unique field.
Somasundaram S 1Somasundaram S 1
Maddy
         interesting, could you please explain how to avoid to enter duplicate value using workflow.
thanks 
$ Maddy  $$ Maddy $
Create a new field as unique (no duplicate values). 
User-added image

Then create a workflow and update this field with your test field.

I have tested and this is working fine.

User-added image

Please let me know if you have any question.
 
Becka DBecka D
I second the suggestion of using the "unique" requirement on the field level. It will accomplish exactly what you are trying to do.

In addition to what Maddy showed, you would have to do a second step of passing the value from the text field into your unique field (unless you can edit your test field to make that have the unique requirement). The workflow could be as simple as if your test field contains a value, pass that value to your unique field.