+ Start a Discussion
Anthony SudaAnthony 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?

sanjdevsanjdev

Hi,

 

Picklist field is not supported in Vlookup formula field.

 

Mark it as resolved if it helps you.

Sanj.

Anthony SudaAnthony Suda

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??

Sudhakar ReddySudhakar Reddy

In VLookUP function,field_to_return should not be a picklist.