Please enable JavaScript to view this site.

ModelMuse Help

Navigation: Formulas > Functions > Text

PositionInList

Scroll Prev Top Next More

PositionInList(TestTextItem, FirstTextItem, SecondTextItem, ...) compares TestTextItem to each of the succeeding items in order until it finds a match and then returns the position of the matching item in the list of items. If no match is found, PositionInList returns zero.

PositionInList is case sensitive.

Examples:

PositionInList("b," "a," "b," "c") returns 2.

PositionInList("B," "a," "b," "c") returns 0.