DE.INDEX
Returns the index number for a specified element in a specified dimension. DE.INDEX is one-based and so returns 1 for the first element in the dimension. If an element is not found, the function returns 0.
Syntax
DE.INDEX(Database alias,Dimension,Element)
Dimension is the name of the dimension containing the element whose index number you want to determine and Element is the element.
Arguments to this function can be strings, or references to cells containing strings. If strings, they must be enclosed in quotes.
If the selected dimension or element does not exist, the function returns a #Value error.