function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Sudhakar ReddySudhakar Reddy 

Vlook_up function

 

 can any one please explain me how to use VLOOK_UP function() in real time sample example?

VLookup(field_to_return,field_on_lookup_object,lookup value).

 

priyanka.mv26priyanka.mv26

My business requirement is to select a State value based on city value. 

 

I cannot do this through dependent picklist as I have nearly 1000 values in my city values.

 

So I will create a object which maps the city to the state

 

Here i can use Vlookup(city__c,state__c,'Chennai')

 

Please let me know if you didn't understand, I will explain in detail
Sudhakar ReddySudhakar Reddy

Thanks a lot Priyanaka.

 

 Vlookup(city__c,state__c,'Chennai')

 

 from the above example,if state_c field value chennai,then it will return the value of city_c field value?am I correct?

 

 

 It seems you are in Chennai.I am also in chennai.Can you please give your email id or phone no to get clear doubts.

It seems you are working on salesforce with real time project.
priyanka.mv26priyanka.mv26

the Vlookup function will return value as 'Tamil Nadu'