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!






  • @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