Help: Converting a line item text to list

Hello, On the level 1 modelling exam I am getting stuck with a error when trying to convert a text line item to a list. Has anyone had similar error or know how to resolve? Many Thanks in advance!

 

 

 

  Capture1.PNG

Comments

  • @mrahma16 

     

    In order to convert Text Formatted Line item into List Formatted Line item we use FINDITEM function

     

    Line item 1 - Formatted as Text

    Line item 2 - FINDITEM(List 1, Line item 1)

     

    Here List 1 is the name of the list from where you want to check if the text in Line item 1 matches any item in List 1

     

    Hope that helps

    Misbah