Hi,

I am trying to use Vlookup() but keep getting error - Error: Incorrect parameter for function 'VLOOKUP()'.
i am using validation rule:
Expense_Total__c > VLOOKUP($ObjectType.Expense_Limit__c.Fields.Monthly_Expense_Limit__c, $ObjectType.Expense_Limit__c.Fields.Name, Role__c)

Rule is that total Expense must be less than or equal to user role's monthly expense limit.

Expense_Total_c is custom field (from roll up summary SUM)
$ObjectType.Expense_Limit__c.Fields.Monthly_Expense_Limit__c is field under an object (currency)
$ObjectType.Expense_Limit__c.Fields.Name is name field of record name (text 80)
Role__c is custom field (text 80) for user to key in role (i use formula $UserRole.Name also gives error when validate the formula)

I can't figure out where is wrong...anyone can help?

Hi,

I am trying to use Vlookup() but keep getting error - Error: Incorrect parameter for function 'VLOOKUP()'.
i am using validation rule:
Expense_Total__c > VLOOKUP($ObjectType.Expense_Limit__c.Fields.Monthly_Expense_Limit__c, $ObjectType.Expense_Limit__c.Fields.Name, Role__c)

Rule is that total Expense must be less than or equal to user role's monthly expense limit.

Expense_Total_c is custom field (from roll up summary SUM)
$ObjectType.Expense_Limit__c.Fields.Monthly_Expense_Limit__c is field under an object (currency)
$ObjectType.Expense_Limit__c.Fields.Name is name field of record name (text 80)
Role__c is custom field (text 80) for user to key in role (i use formula $UserRole.Name also gives error when validate the formula)

I can't figure out where is wrong...anyone can help?