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


thank you




  • @RavinderB 

    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.