I'm not too versed in Excel but I am learning quickly and I'm having trouble with outputting data based upon selection from drop down list. Here's what I'm trying to do. I have build drop-down lists which let the user first select a name, then category and then based upon their category selection, they select from a sub-category. What I want to do is based upon the sub-category they select, I would like to output a string of text based upon values they have selected from the drop down lists.
Example would be the user selects Tom from the drop down name list. User then selects Food from the Category List. User then selects Breakfast from the Sub-Category List (in column B4).
What I would like to do is output a string of text for everything listed under my Breakfast category that I have listed on Sheet2. On Sheet2 under Breakfast, I have the following values: Cereal, Toast, Pancakes (each listed in their own cell). Here's how I would like to have the output displayed on Sheet1:
Tom Cereal
Tom Toast
Tom Pancakes
What is the easiest way for me to achieve this? I tried the following statement:
=IF(B4='Breakfast',Sheet2!Breakfast,"")
What happens is it only outputs Tom Pancakes. How do I make it output each line instead of just the last line? Do I need to use a counter function? Any help would be appreciated!