Apex Code Development You need to sign in to do that
Don't have an account?
DRPowerUser 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)
werewolfVLOOKUP 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)?
DRPowerUserYes, I am trying to use it in a VLOOKUP formula just like in Excel to populate a text value in a field.