I have 10 student names put in from cell a1 to a10 in sheet1, and their age
put in from b1 to b10.  I created a list of student names by selecting cell
a1 to a10.  I go to sheet2, cell a1: I created a drop drop list of student
name.  I want cell b1 in sheet2 to auto pop up the age of whoever I choose
from the drop down list in cell a1:sheet2.  The age is according to the age
entered in sheet1.  What is the exact formulas for me to this in cell
b1:sheet2 or is this possible at all?