Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using a drop-down list along with an auto-populate drop-down
I have created a drop down list of scores ranging from 1.0 to 4.0 in .1
increments. On the first drop down the user is able to select the score, let's say 3.9 and then I want Excel to auto populate a nearby cell with the grade A+. How do I do this? There does not seem to be an "auto populate" feature based on an already existing drop down list. Help!!! & Thanks!!! Rosser |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using a drop-down list along with an auto-populate drop-down
Check out VLOOKUP function.
Better yet................. See Debra Dalgleish's site for more on VLOOKUP and Data Validation lists for entering the choices. http://www.contextures.on.ca/xlFunctions02.html http://www.contextures.on.ca/xlDataVal01.html Note the section on using DV lists from another worksheet by naming the list. BTW: 1.0 to 4.0 incremented by .1 is 31 values to attach a letter grade to. Do you need that many? Gord Dibben MS Excel MVP On Mon, 16 Apr 2007 15:52:02 -0700, CrazyLostConfused wrote: I have created a drop down list of scores ranging from 1.0 to 4.0 in .1 increments. On the first drop down the user is able to select the score, let's say 3.9 and then I want Excel to auto populate a nearby cell with the grade A+. How do I do this? There does not seem to be an "auto populate" feature based on an already existing drop down list. Help!!! & Thanks!!! Rosser |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Fill from Drop Down list | Excel Worksheet Functions | |||
auto populate cell based on previous cell drop down list selectio. | Excel Discussion (Misc queries) | |||
Auto populate several cells based on a selection from drop down li | Excel Discussion (Misc queries) | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
Populate Drop Down List | Excel Worksheet Functions |