lookup and error message
Please advise on what this error means : lookup error - please see image attached - thank you
IF Employed? THEN 'EMP03 Employee Drivers By Role'.Car Allowance[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0
data type mismatch : format other than LIST or DATE being referenced as a relation
please see attached error
role is in a list and formatted as a text field
LOOKUPS require a time period or List formatted line item NOT Text.
Update the line item in the mapping and convert it to a list format.
Use FINDITEM to do this.
Hi @RavinderB ,
Lookup can only use a List or Date formatted item. So the error is saying that in your lookup you are using something other than the to. And as you say that role is text the LOOKUP formula does not acept it.
You have to turn the role LI into a list and use it as the line item format to use it for lookup.
@RavinderB Agree with both @Ingilavicus and @ChrisAHeathcote . Just change the format of "Role" Line item from TEXT to Role List. That would help resolve the Lookup error.
Hope this helps.