Syntax for Element is: “Variable = element(Search_Value,Search_Array,Return_Array)”.
The “Element” function is similar to a “Lookup” function in Microsoft Excel. It will find the appropriate row in a Search_Array, and return the corresponding value in Return_Array.
As an example, enter the rules “Car Model = {Mercedes, Porsche, Honda}” and “Car Price = {70000,90000,30000}”. Finding the price of the Porsche could be “Result = element(Porsche,Car Model,Car Price)”.
In this example, the Element function will look for “Porsche” in Car Model and find it in the second item. The function will then return the second item from Car Price.