How do I set up a combo box to select one value but pas an other .

[Guest]

I have an Excel sheet setup to do a calculation based on a wire size.
Each wire size has a value to use for a multiplier for the formula.

Is there a way that I can set it up so that I can select a wire size from a
combo box and through that selection pass the value associated with that wire
size to my formula?

Thanks in advance

 

[Tom Ogilvy]

You could use Data=>Validation to display wire sizes. Then in your
formula, use the vlookup function to find the selected wire in a table and
return the multiplier.

See Debra Dalgleish's site for information on using Data Validation
http://www.contextures.com/tiptech.html

Data validation is found under D

look in Excel Help for the information on Vlookup. It would require a table
like

Wire Multiplier
aaa 2.1
bbb 3.5
ccc 4.0


as an example.