Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing cell value according to list value
Hello! I have a list of 1 to 10 ($A$1:$A$10). In the column beside the
numbers, I have names ($B$1:$b$10). In cell $C$1, I created a validation list of my numbers. In cell $D$1, I'll like to change my names according to the number I choose in my list. So lets say I have like data: A1 = 1 , B1 = Toto A2 = 2 , B2 = Tata A3 = 3 , B3 = Titi .. .. .. When I select from my drop down menu in C1 the number 2, I want it to display in D1 : Tata. When I select from my drop down menu in C1 the number 3, I want it to display in D1 : Titi. How would I go about doing this? thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing cell value according to list value
Hi
Enter in cell D1 =VLOOKUP($C1,$A$1:$B$10,2) Copy down as required -- Regards Roger Govier "Ninjapowa" wrote in message ... Hello! I have a list of 1 to 10 ($A$1:$A$10). In the column beside the numbers, I have names ($B$1:$b$10). In cell $C$1, I created a validation list of my numbers. In cell $D$1, I'll like to change my names according to the number I choose in my list. So lets say I have like data: A1 = 1 , B1 = Toto A2 = 2 , B2 = Tata A3 = 3 , B3 = Titi . . . When I select from my drop down menu in C1 the number 2, I want it to display in D1 : Tata. When I select from my drop down menu in C1 the number 3, I want it to display in D1 : Titi. How would I go about doing this? thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
Automatically Changing Cell Reference's when Pasting in Excel | Excel Discussion (Misc queries) | |||
Ooh .. Linking a list to a list to an output cell | Excel Discussion (Misc queries) | |||
Problem with formulas changing cell reference | Excel Discussion (Misc queries) | |||
List ? - How do I make information in one cell determine list to u | Excel Worksheet Functions |