Hi!
Basically, I have 3 sheets in one workbook.
Sheet 1 is the data that I will use as a list for data validation.
Sheet 2 is a list of questionnaire, where we will score them based on the replies
Sheet 3 is the scoring page, where the final score will be tabulated
Based on my example above, Sheet 1 will have the scores manually keyed in for each person. On Sheet 2 (B1), I will select the list of names using data validation, referring back to Sheet 1 (B2:B12).
Finally, on Sheet 3, it will automatically shows that Mike's score is 3, Excellent (A2:B2) based on his result in Sheet 1, which is 90. I need the formula for Sheet 3, A2 and B2.
Thanks!
Irene
Basically, I have 3 sheets in one workbook.
Sheet 1 is the data that I will use as a list for data validation.
Sheet 2 is a list of questionnaire, where we will score them based on the replies
Sheet 3 is the scoring page, where the final score will be tabulated
Based on my example above, Sheet 1 will have the scores manually keyed in for each person. On Sheet 2 (B1), I will select the list of names using data validation, referring back to Sheet 1 (B2:B12).
Finally, on Sheet 3, it will automatically shows that Mike's score is 3, Excellent (A2:B2) based on his result in Sheet 1, which is 90. I need the formula for Sheet 3, A2 and B2.
Thanks!
Irene