rajagopal
05-24-2007, 01:55 AM
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
05-24-2007, 02:15 AM
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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.