Hi All,
I would like to use Excel to create a comparison table, the idea is that in first sheet, it provided three drop-down list for user to select, the list items is related to another sheet database. Once the user selects one item, its related information contained in the database will show up accordingly. Example is like...
In Sheet2, there are information like
Person1, 80, 85, 90, 92
Person2, 70, 71, 99, 85
Person3, 60, 98, 93, 91
Person4, 30, 55, 97, 100
In Sheet1, there are two drop-down button, each one has option of Person1/Person2/Person3/Person4. If user chooses Person1/Person4, their corresponding data will be listed by searching Sheet2 information, and then user could compare their difference.
Which command/formula could I use to achieve this task? Thanks all of you in advance for helping.
I would like to use Excel to create a comparison table, the idea is that in first sheet, it provided three drop-down list for user to select, the list items is related to another sheet database. Once the user selects one item, its related information contained in the database will show up accordingly. Example is like...
In Sheet2, there are information like
Person1, 80, 85, 90, 92
Person2, 70, 71, 99, 85
Person3, 60, 98, 93, 91
Person4, 30, 55, 97, 100
In Sheet1, there are two drop-down button, each one has option of Person1/Person2/Person3/Person4. If user chooses Person1/Person4, their corresponding data will be listed by searching Sheet2 information, and then user could compare their difference.
Which command/formula could I use to achieve this task? Thanks all of you in advance for helping.
