Thread: VLOOKUP Multiple Entries

I have a Sheet PRODUCTDB which contains various styles. Each style is available in various materials and each material in various colors.

[PRODUCTDB]
STYLE, MATERIAL, COLOR
COSMO, ONE, Black
COSMO, ONE, Red
COSMO, ONE, Black
COSMO, TWO, Black

This is my main Dataentry and i control all styles on this Sheet. Now i want a separate ORDER sheet. In a perfect world i would have a field where i type in the style ... and i get a selection of MATERIALS who are available with the style, once i've chosen the material ... i get all colors listed.

[ORDER]
COSMO > SELECT ONE, TWO
ONE > SELECT Black, Red, Black

I know there is the =IF(ISERROR ..... Function ... but i'm sure a smart script would do the job a lot better ... but i suck with scripts. Thank you for your help ...