dependent cells

[mdkusername]

I have a set of primary codes that are associated with multiple secondary codes (secondary code groups). Each primary code is associated with a secondary code group, some primary codes have the same secondary groups.
The primary codes are listed with their secondary code groups.

I would like (primary matched secondary) to make a drop down list of primary codes. When the primary code is selected I would the cells to populate with the codes that are in the secondary code group associated with the selected primary code

 

[PeteWright]

I think you missed to point out which part of secondary code to choose.

If, for example, you choose "001 Description" as "Primary code & description" then there are too many options left for the "secondary code".

Could you clarify?

 

[mdkusername]

In column A are listed the primary code and description and the associated secondary code group. The secondary code group is defined in the secondary group data sheet. What I am trying to do on sheet "primary matched secondary" is when I chose a primary code from the drop down the individual items in the associated secondary code group are displayed. So if I chose "001 description" from the drop down then the secondary code and the secondary code group items corresponding to the code group 1 would be dispalyed in the 2 columns below.

 

[PeteWright]

Give this a try:

These are the sheets:

Set up a Data Validation:

Enter formulas:

A3 = INDEX(SGD!$1:$1048576;ROW()-1;XMATCH(XLOOKUP($A$2;PCD!$A:$A;PCD!$B:$B;"";0);SGD!$1:$1;0;1))

B3 = INDEX(SGD!$1:$1048576;ROW()-1;XMATCH(XLOOKUP($A$2;PCD!$A:$A;PCD!$B:$B;"";0);SGD!$1:$1;0;1)+1)

The result:

Please let me know if this works for you.

 

[mdkusername]

Give this a try:

These are the sheets:
View attachment 116931

View attachment 116932

View attachment 116934

Set up a Data Validation:
View attachment 116935

Enter formulas:

A3 = INDEX(SGD!$1:$1048576;ROW()-1;XMATCH(XLOOKUP($A$2;PCD!$A:$A;PCD!$B:$B;"";0);SGD!$1:$1;0;1))

B3 = INDEX(SGD!$1:$1048576;ROW()-1;XMATCH(XLOOKUP($A$2;PCD!$A:$A;PCD!$B:$B;"";0);SGD!$1:$1;0;1)+1)

The result:
View attachment 116937

Please let me know if this works for you.

Tried to troubleshoot formula but cannot make it work. Thanks for taking the time and attention.

 

[PeteWright]

Sorry, my fault. Have been working on another computer with different regional settings.
Replace all semicolons with commas or copy and paste:

A3 = INDEX(SGD!$1:$1048576,ROW()-1,XMATCH(XLOOKUP($A$2,PCD!$A:$A,PCD!$B:$B,"",0),SGD!$1:$1,0,1))

B3 = INDEX(SGD!$1:$1048576,ROW()-1,XMATCH(XLOOKUP($A$2,PCD!$A:$A,PCD!$B:$B,"",0),SGD!$1:$1,0,1)+1)

Keep in mind that I named my worksheets differently.