Dropdown list based on a key.

Hi everybody.

I am having so much trouble trying to make this work.

The problem is this:

I am dealing with about 3000 entries.

In one sheet I have this information:
TABLE01

mukey Comp_Domt
127961 Philo
2401228 Pope
2401229 Nelse
2401230 Craigsville

mukey is a single instance, this number does not repeat in this table.

But in another table this mukey has 4~5 components:

TABLE02
mukey compname
127960 Axis
127961 Beaches
127961 Klej
127961 Purnell
127961 Runclint
127961 Acquango
127962 Bibb
127963 Bibb variant
127964 Butlertown
127964 Mattapex
127964 Unnamed soils
127964 OTHELLO

I would like to create on TABLE01 under 'Comp_Domt' a dropdown menu for each mukey showing a component list with the same key from the table 2
That way I would select what component from the list represents best that mukey.

If I click in 'philo' on TABLE01 I want a dropdown menu with these Items from TABLE02 : Beaches,Klej,Purnell,Runclint,Acquango for me to select.

Any help on solving that would be awesome.

Thank you so much!

Hi

Something like this?

I'm pretty sure you're going to need VBA if you want 3000 different dropdowns