R
Richard
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?
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?