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!
0
Comments
-
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
3