Home > Forum Home > Presenting and Reporting Data > drop down list to reflect multiplier Share

Drop down list to reflect multiplier

Excel Help for Drop Down List To Reflect Multiplier in Presenting and Reporting Data

Forum TopicPost Reply Login

Drop Down List To Reflect Multiplier

Rate this:
(3/5 from 1 vote)
ConfusedI am trying to figure out the formula to select text in a drop down and have tht text linked to a multiplier in another cell on the same line in a different column.  Example would be "RS" drop the drop down in B2 and when I select that the multipler in B6 would need to change to .98.  Next line might be "ACC" in the drop down and the multipler would change to .90.
 Posted by on
Replies - Displaying 1 to 1 of 1Order Replies By: Most Recent | Chronological | Highest Rated
Rate this:
(2.5/5 from 2 votes)
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.
 Excel Business Forums Administrator
 Posted by on
 Displaying page 1 of 1 

Excel templates and solutions matched for drop down list to reflect multiplier:

Solutions: Office 365 Classic Menu