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
Bookmarks