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?

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?

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?

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?