Help!! Excel novice - Automatically give a value to another cell when a user selects an option from a drop down menu



I quickly need to understand how to do this.

I have created a data validation option for a cell and using it in a number of cells.  There are four options, lets call them A B C and D.  When a user selects say A in cell C1 I want Excel to automitcally enter a value for A say 10 to another cell in A1.  So user selects A in C1 and automically 10 appears in A1, is this possible?

If so I would like four rules created for this so when an option is selected these numbers are automatically entered into the other cell.

A - 10

B - 6

C - 2

D - 0

Thanks in advance for any answers it will be hugely appreciated.

Many thanks



MAQ answered your question, but I'd you don't want to put a formula (so the user can change the value of the cell), we could help you in that too - using VBA and Macros
MRVMV (rep: 52) Jul 22, '16 at 5:13 pm
Add to Discussion



Probably lots of different ways to do this.  If it were me, i would make a little loookup table (it doesn't have to be on the same sheet and can even be on a hidden sheet) and do a vlookup.  Example attached.


Answer the Question

You must create an account to use the forum. Create an Account or Login