Not very familiar with drop down lists in excel but this is what I would like to do...

1. I want to have one column that lists out the different models that can be used (with descriptive names)

2. When that drop down list box is changed, it will change a formula that is linked to this cell with the model code

Not sure if it's possible to have several names in a list and have a underlying code that will then be used in the formula.

The reason for this is that I want the user to be able to switch between models easily while not having to worry about each individual model code