what is vlook up ? explain with example - Answers - Salesforce Trailblazer Community
Trailblazer Community
Ask Search:
sandeep psandeep p 

what is vlook up ? explain with example

Damien OwenDamien Owen
Hi Sandeep,

See the following post from @Deepak that gives a great explanation for VLOOKUP with an example.

https://success.salesforce.com/answers?id=90630000000gyFzAAI

Let us know if you're still unclear about any aspect of the VLOOKUP function.

Thanks
Damien
Johan YuJohan Yu
Unfortunately, vlookup() is only available in validation rules. 
It will be very nice if Salesforce expand it to formula field and workflow rule
here is the idea  https://success.salesforce.com/ideaView?id=08730000000BqPsAAK 
Jeff SummersJeff Summers
Agree with Johan.  It is something I use quite a bit in Excel.