You need to sign in to do that
Don't have an account?
Anthony Suda
VLOOKUP validation error... not matching manual's description
Part of my validation rule looks like this:
VLOOKUP($User.Floor__c, $User.Username, Employee_Name__c)
User.Floor__c is a picklist field. When i check the syntax of this, i get:
Error: Field Floor__c is a picklist field. Picklist fields are only supported in certain functions.
Yet in the manual it clearly says for VLOOKUP:
The field_to_return must be an auto number, roll-up summary, lookup relationship, master-detail relationship, checkbox, date, date/time, email, number, percent, phone, picklist, text, text area, or URL field type.
What's the deal here? the field I'm wanting to return is a picklist... it should be returning that.... right??? What am I missing here?
Hi,
Picklist field is not supported in Vlookup formula field.
Mark it as resolved if it helps you.
Sanj.
Excuse me but can you read the first tip here in the manual for VLOOKUP:
https://help.salesforce.com/apex/HTViewHelpDoc?id=customize_functions.htm&language=en_US#VLOOKUP
note how it says
The field_to_return must be an auto number, roll-up summary, lookup relationship, master-detail relationship, checkbox, date, date/time, email, number, percent, phone, picklist, text, text area, or URL field type.
So you're saying the manual is wrong??
In VLookUP function,field_to_return should not be a picklist.