Linking choices in drop down menu to have automatic answer...

U

Unieeban

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?
 
U

Unieeban

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
 
R

Roger Govier

Hi

If you paste Biff's formula in B1 and copy down, that is what you will get.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop Down choice needs to lead to another drop down menu 1
Copying a Drop Down Menu 2
Drop Down Menu Conditional Formatting 4
How to make items in a drop down menu reference a number 2
Drop Down Menu 4
Multi layered drop down 1
conditional drop down menu 1
Drop down menu display based on the value of different cell 2

Top