Hello All,
Thank in advance.
I have 2 dropdowns (validation list). One dropdown contains a list of "first names" 10 of them, the second contains a list of "last names" 10 of them also. When someone chooses a combination of "john" and "smith" (for example) from the individual dropdowns then cell A2 returns the value of "good student". The word "good student" is located on another sheet, I just want to point to it. Sheet2!A50 (for example). If someone chooses the combination "jane" and "wilson" then it will return the value "bad student" from another sheet.
I need to be able use the formula in 1 cell. That cell value continues to change as people choose different "first" and "last" names.
What is a good formula to accomplsih this?
Thank in advance.
I have 2 dropdowns (validation list). One dropdown contains a list of "first names" 10 of them, the second contains a list of "last names" 10 of them also. When someone chooses a combination of "john" and "smith" (for example) from the individual dropdowns then cell A2 returns the value of "good student". The word "good student" is located on another sheet, I just want to point to it. Sheet2!A50 (for example). If someone chooses the combination "jane" and "wilson" then it will return the value "bad student" from another sheet.
I need to be able use the formula in 1 cell. That cell value continues to change as people choose different "first" and "last" names.
What is a good formula to accomplsih this?