ExcelHelpNecessary
New member
- Joined
- Jan 14, 2021
- Messages
- 5
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2016
I have a table with the following data:
Rows: Names of People
Columns: Fruits
Is there anyway to set up a dropdown list with all the names, then in a listing display any columns next to their name with data inside?
ie: there are 6 columns (orange, apple, banana, grape, pear, melon) and Clarence has "yes" under the orange, banana and pear columns. How can I set up a dropdown so it shows all the names, and when you click Clarence it shows, in a list, like such:
Orange
Banana
Pear
Excel 2016 please
I've attached a sample workbook.
Thanks for any help!
Rows: Names of People
Columns: Fruits
Is there anyway to set up a dropdown list with all the names, then in a listing display any columns next to their name with data inside?
ie: there are 6 columns (orange, apple, banana, grape, pear, melon) and Clarence has "yes" under the orange, banana and pear columns. How can I set up a dropdown so it shows all the names, and when you click Clarence it shows, in a list, like such:
Orange
Banana
Pear
Excel 2016 please
I've attached a sample workbook.
Thanks for any help!
Attachments
Last edited by a moderator: