Solved: auto population of data

[rajagopal]

Cell C2 has list of user names (total of 20 user names) to select.
Cell c3 has to be populated with age of the user selected in cell c2.
How this can be executed automatically?

[Veekay2007]

Step 1: Define your headings. example F1 = Name, G1 = Age
Step 2: Input Data

Step 3: Come to Cell C2

Step 4: Go to Date Menu, click on Validation
from the drop down, click on List.
and set the Column F to refer to.

Step 5: Go to cll C3. type the following formula

=vlookup(C2,F:G,2,0)
You are done.

Now everytime you select any name form the Drop Down, it will display the age in C3

HTH

Veekay

[rajagopal]

Thanks a lot