You can drive cell values from the selected item in a Combo Box form control (drop down box). When creating the combo box define the Input Range as the range where the text values are (RS, ACC etc. in, for example, C5 to C10) and the Cell Link to output the selected index value (In this example cell B5).
Next to the columns of text values (RS, ACC etc.) put the corresponding multiplier values (0.98, 0.90 etc. in cells D5 to D10).
When the combo box selection is changed, we see the index number of the selection in cell B5. Now we can match this to return the multiplier by entering the following formula in cell B6. =INDEX(C5:D10,B5,2)
