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!
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