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
DRPowerUserDRPowerUser 

VLOOKUP Error on Formula

I am trying to create a VLOOKUP formula using information from a custom object.

 

I am getting the message:  “Error: Function VLOOKUP may not be used in this type of formula.  Can anyone explain why I’m getting this error message and how to resolve?

 

Name = Text    (Example: ABCD1)

Subscription_Year = Text (Example: 100)

Combined Pricing Code = Text  (ABCD1)

 

VLOOKUP (

Pricing_Code_Lookup__r.Name,

Pricing_Code_Lookup__r.Subscription_User__c,

Combined_Pricing_Code__c)

werewolfwerewolf
VLOOKUP is only available in validation rules.  Are you perhaps trying to use it in some other kind of formula (formula field or workflow formula perhaps)?
DRPowerUserDRPowerUser
Yes, I am trying to use it in a VLOOKUP formula just like in Excel to populate a text value in a field.