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!