Hi All - Can anybody please let me know how to use vlookup Function in SF. Please provide me some examples if you have.
I want to use it to Validate Zip/Postal Code, State and Country Fields. I have added a custom object with the details of all the countries, their states and Zip and i am trying to reference this custom object through vlookup function but unable to get this done.
Thanks & Regards,
This is how i applied the validation.
AND((OR(Country = "USA",Country = "Australia",Country = "Canada")), VLOOKUP( $ObjectType.State_Abbreviation__c.Fields.Country__c,
State )<> Country
Just to confirm and get it right, the formula you have written return TRUE only if the selected State does NOT belong to either USA/Canada or Australia.
Is that correct?