INDEXOFLIST function is used to find the index of the assigned list value. It’s good at producing a numeric value for list values that follow a scale. The return value index is zero based, i.e., the first value in the list is 0 (zero).

Syntax

INDEXOFLIST(“x”)

Parameters

x = The code of the list attribute you want to use to return the index values on an item.

Type of Data Returned

Numeric

Examples

Assume a list attribute with a code name of “mylist” that possess the labels of: “Low”, “Med”, “High” and “VHigh”.

If an item has been assigned the value of “High”

INDEOXLIST(“mylist”) will return a value of 2

INDEXOFLIST(mylist) will return a value of -1 as the quotations (“”) are missing.

If an item has been assigned the value of “Med”

INDEXOFLIST(“mylist”) will return a value of 1

INDEXOFLIST(mylist) will return a value of -1 as the quotations (“”) are missing.

If the item does not have a value for the attribute coded “mylist”

INDEXOFLIST(“mylist”) will return a value of -1 as no value has been found.