Sounds like perhaps the CHOOSE function ?
from the DC User Guide: Supported Functions page …
CHOOSE function returns a value from a list of parameters at the location of the index value. This function allows you to create a single drop-down list that drives multiple attribute changes at once.
The previous example results in “Red.”
OPTIONINDEX together as a mechanism to assign different values depending on a user’s choice in the Component Options dialog box. For example, if the Component Options dialog box allows the user to choose different materials to assign to a component (and the price changes depending on material chosen), the formula for
MSRP might be:
=CHOOSE (OPTIONINDEX("Material"), 100, 150, 200)
The previous example returns
200 depending on the material chosen in the Component Options dialog box.