Nicholas Chew
New Member
- Joined
- Nov 2, 2014
- Messages
- 11
Hi all,
Having trouble on these few methods. I'm new to excel so guy i need your help.
I have a list of different product items example:
Marigold Orange Juice
Marigold Apple Juice
Sunkist Orange Juice
Sunkist Apple Juice
Tropicana Orange Juice
Tropicana Apple Juice
All of these i have group them in the Name Manager called Product_items.
On my sheet2 i created a table which has a dropdown list which I can select my 3 different brands( Marigold, Sunkist and Tropicana). On the second column will be showing all different brand and juice. Problems lies here if i select Marigold as my brand. On the next column how do I show only Marigold Orange Juice & Marigold Apple Juice? I can only show the whole list of the Product_items which is incorrect. Must i use If and vlookup?
Having trouble on these few methods. I'm new to excel so guy i need your help.
I have a list of different product items example:
Marigold Orange Juice
Marigold Apple Juice
Sunkist Orange Juice
Sunkist Apple Juice
Tropicana Orange Juice
Tropicana Apple Juice
All of these i have group them in the Name Manager called Product_items.
On my sheet2 i created a table which has a dropdown list which I can select my 3 different brands( Marigold, Sunkist and Tropicana). On the second column will be showing all different brand and juice. Problems lies here if i select Marigold as my brand. On the next column how do I show only Marigold Orange Juice & Marigold Apple Juice? I can only show the whole list of the Product_items which is incorrect. Must i use If and vlookup?
