Text Lookup?

[gmooney]

Hello, I have a long list of 2 columns. The first column contains categories and the second column contains sub categories of those categories. Each category can have a variable amount of sub categories. I have a combo box that let's the user select from the categories and this in turn lists the selected category in a cell. I now need to be able to list just the sub catogories that are assigned to the selected category and list them in their own cells:


Here is the list of categories and sub categories: (These are in 2 different columns)

APPLES ALL OTHER VARIETIES
APPLES FUJI
APPLES GALA
APPLES GRANNY SMITH
APPLES HONEYCRISP
APPLES RED DELICIOUS
BERRIES ALL OTHER VARIETIES
BERRIES BLACKBERRIES
BERRIES BLUEBERRIES
BERRIES ORGANIC
BERRIES RASPBERRIES
BERRIES STRAWBERRIES
BROCCOLI ASPARATION/BROCCOLINI
BROCCOLI ORGANIC
BROCCOLI OTHER
BROCCOLI RABE (CHINESE, ITALIAN, RAPINI)
BROCCOLI REGULAR
CARROTS BABY
CARROTS BULK
CARROTS CELLO
CARROTS ORGANIC


Say that the user has selected Carrots from the combo box. I now want in new cells to post the following: (These are in 2 different columns)

CARROTS BABY
CARROTS BULK
CARROTS CELLO
CARROTS ORGANIC


Any help would be greatly appreciated!!!!!

 

[VoG]

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

 

[T. Valko]

Hello, I have a long list of 2 columns. The first column contains categories and the second column contains sub categories of those categories. Each category can have a variable amount of sub categories. I have a combo box that let's the user select from the categories and this in turn lists the selected category in a cell. I now need to be able to list just the sub catogories that are assigned to the selected category and list them in their own cells:


Here is the list of categories and sub categories: (These are in 2 different columns)

APPLES ALL OTHER VARIETIES
APPLES FUJI
APPLES GALA
APPLES GRANNY SMITH
APPLES HONEYCRISP
APPLES RED DELICIOUS
BERRIES ALL OTHER VARIETIES
BERRIES BLACKBERRIES
BERRIES BLUEBERRIES
BERRIES ORGANIC
BERRIES RASPBERRIES
BERRIES STRAWBERRIES
BROCCOLI ASPARATION/BROCCOLINI
BROCCOLI ORGANIC
BROCCOLI OTHER
BROCCOLI RABE (CHINESE, ITALIAN, RAPINI)
BROCCOLI REGULAR
CARROTS BABY
CARROTS BULK
CARROTS CELLO
CARROTS ORGANIC


Say that the user has selected Carrots from the combo box. I now want in new cells to post the following: (These are in 2 different columns)

CARROTS BABY
CARROTS BULK
CARROTS CELLO
CARROTS ORGANIC


Any help would be greatly appreciated!!!!!

Is this what you had in mind:

http://www.mrexcel.com/forum/showpost.php?p=2696961&postcount=3

 

[gmooney]

Thank you T. Valko...this works perfectly...not I have one more element to add to this.....every set up sub categories that will be returned contains a sub category called ALL OTHER VARIETIES. I need for this to be listed as the last sub category every time.....Thoughts?

 

[T. Valko]

Thank you T. Valko...this works perfectly...not I have one more element to add to this.....every set up sub categories that will be returned contains a sub category called ALL OTHER VARIETIES. I need for this to be listed as the last sub category every time.....Thoughts?

There isn't an "ALL OTHER VARIETIES" for every category in the sample data?

The easy fix would be to rearrange the raw data so that that category is listed last:

APPLES FUJI
APPLES GALA
APPLES GRANNY SMITH
APPLES HONEYCRISP
APPLES RED DELICIOUS
APPLES ALL OTHER VARIETIES
BERRIES BLACKBERRIES
BERRIES BLUEBERRIES
BERRIES ORGANIC
BERRIES RASPBERRIES
BERRIES STRAWBERRIES
BERRIES ALL OTHER VARIETIES
BROCCOLI ASPARATION/BROCCOLINI
BROCCOLI ORGANIC
BROCCOLI OTHER
BROCCOLI RABE (CHINESE, ITALIAN, RAPINI)
BROCCOLI REGULAR
CARROTS BABY
CARROTS BULK
CARROTS CELLO
CARROTS ORGANIC

Is that possible?