Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking choices in drop down menu to have automatic answer...
In my excel project, I've created a drop down menu in one cell. In the
adjacent cell, I want to have answers automatically generated when you choose one of the choices in the drop down menu. For example, in the drop down menu I have: DROP DOWN MENU SCORE Ideal Client 3 Handholding 2 Not Ideal 1 If I chose Ideal Client from the drop menu, I want the next cell to automatically give the score of 3. How can I do this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking choices in drop down menu to have automatic answer...
If you only have a "few" selections:
A1 = drop down list =IF(A1="Ideal Client",3,IF(A1="Handholding",2,IF(A1="Not Ideal",1,""))) If you have many selections then you should create a lookup table: http://contextures.com/xlFunctions02.html -- Biff Microsoft Excel MVP "Unieeban" wrote in message ... In my excel project, I've created a drop down menu in one cell. In the adjacent cell, I want to have answers automatically generated when you choose one of the choices in the drop down menu. For example, in the drop down menu I have: DROP DOWN MENU SCORE Ideal Client 3 Handholding 2 Not Ideal 1 If I chose Ideal Client from the drop menu, I want the next cell to automatically give the score of 3. How can I do this? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking choices in drop down menu to have automatic answer...
Still confused...
Column One has drop down Ideal Client Needs Work No Ideal Column Two should automatically generate these numbers: Ideal Client = 3 Needs Work = 2 No Ideal = 1 "T. Valko" wrote: If you only have a "few" selections: A1 = drop down list =IF(A1="Ideal Client",3,IF(A1="Handholding",2,IF(A1="Not Ideal",1,""))) If you have many selections then you should create a lookup table: http://contextures.com/xlFunctions02.html -- Biff Microsoft Excel MVP "Unieeban" wrote in message ... In my excel project, I've created a drop down menu in one cell. In the adjacent cell, I want to have answers automatically generated when you choose one of the choices in the drop down menu. For example, in the drop down menu I have: DROP DOWN MENU SCORE Ideal Client 3 Handholding 2 Not Ideal 1 If I chose Ideal Client from the drop menu, I want the next cell to automatically give the score of 3. How can I do this? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking choices in drop down menu to have automatic answer...
Hi
If you paste Biff's formula in B1 and copy down, that is what you will get. -- Regards Roger Govier "Unieeban" wrote in message ... Still confused... Column One has drop down Ideal Client Needs Work No Ideal Column Two should automatically generate these numbers: Ideal Client = 3 Needs Work = 2 No Ideal = 1 "T. Valko" wrote: If you only have a "few" selections: A1 = drop down list =IF(A1="Ideal Client",3,IF(A1="Handholding",2,IF(A1="Not Ideal",1,""))) If you have many selections then you should create a lookup table: http://contextures.com/xlFunctions02.html -- Biff Microsoft Excel MVP "Unieeban" wrote in message ... In my excel project, I've created a drop down menu in one cell. In the adjacent cell, I want to have answers automatically generated when you choose one of the choices in the drop down menu. For example, in the drop down menu I have: DROP DOWN MENU SCORE Ideal Client 3 Handholding 2 Not Ideal 1 If I chose Ideal Client from the drop menu, I want the next cell to automatically give the score of 3. How can I do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I make a drop-down menu without cells containing the choices? | Excel Discussion (Misc queries) | |||
Default value in Drop down menu and automatic selections | Excel Worksheet Functions | |||
Automatic data entry in alternate cells based on drop-down menu se | Excel Worksheet Functions | |||
how do i export information from an answer from a drop down menu? | Excel Worksheet Functions | |||
Developing macro event to allow multiple choices on drop down menu | Excel Worksheet Functions |