Excel If and vlookup

[Nicholas Chew]

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?

 

[Jon von der Heyden]

Hi Nicholas

This tutorial seems like it was written just for you

http://www.contextures.com/xlDataVal02.html

 

[Nicholas Chew]

WOW. That really helped.