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!

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!