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?

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?