Data Validation using Offset

[Pestomania]

Hello all!!
So, I am trying to get an offset to work under a data validation. I have used an old forum to understand how to develop an offset that provides the unique "available steps" based on the table on the right for each program. It returns the appropriate steps. But I would like to use that to create a data validation drop down, but data validation returns and error when I attempt to do that. Can someone assist me in understanding what I have done wrong?

B2:B14 uses an indirect based on a name range, but I want to maintain the autonomy that if the results in the table on the right change, the dropdown auto-updates using the offset, but I am unable to get it to work. Any thoughts?

I am using Microsoft 365 for Enterprise, Version 2402.

Prestons Playground for Modeling.xlsx
	A	B	C	D	E	F	G
1	Program Name	Step Name				Program Name	Available Steps
2	Program 1		Operation 2			Program 1	Operation 2
3	Program 1		Operation 6			Program 1	Operation 6
4	Program 2		Operation 10			Program 1	Operation 6
5	Program 2		Operation 1			Program 1	Operation 10
6	Program 2		Operation 9			Program 1	Operation 1
7	Program 2		Operation 4			Program 1	Operation 9
8	Program 3		Operation 8			Program 1	Operation 4
9	Program 3					Program 1	Operation 8
10	Program 3					Program 1	Operation 8
11	Program 3					Program 1	Operation 1
12	Program 4					Program 1	Operation 9
13	Program 4					Program 2	Operation 10
14	Program 4					Program 2	Operation 1
15						Program 2	Operation 1
16						Program 2	Operation 6
17						Program 2	Operation 4
18						Program 2	Operation 1
19						Program 2	Operation 4
20						Program 2	Operation 4
21						Program 2	Operation 1
22						Program 2	Operation 7
23						Program 2	Operation 10
24						Program 2	Operation 1
25						Program 2	Operation 1
26						Program 2	Operation 7
27						Program 2	Operation 5
28						Program 2	Operation 6
29						Program 2	Operation 2
30						Program 2	Operation 5
31						Program 2	Operation 5
32						Program 3	Operation 5
33						Program 3	Operation 4
34						Program 3	Operation 1
35						Program 3	Operation 3
36						Program 3	Operation 2
37						Program 3	Operation 9
38						Program 3	Operation 5
39						Program 4	Operation 2
40						Program 4	Operation 7
41						Program 4	Operation 3
42						Program 4	Operation 3
43						Program 4	Operation 5
44						Program 4	Operation 6
45						Program 4	Operation 3
46						Program 4	Operation 3
47						Program 4	Operation 9
48						Program 4	Operation 3
49						Program 4	Operation 2
50						Program 4	Operation 7
51						Program 4	Operation 7
52						Program 4	Operation 8
Sheet7

Cell Formulas
Range	Formula
C2:C8	C2	=UNIQUE(OFFSET(JT_UDT_CAP_MOD_PROGRAM_SCHED[Available Steps],MATCH(JT_UDT_CAP_MOD_STEP_ATT[@[Program Name]],JT_UDT_CAP_MOD_PROGRAM_SCHED[Program Name],0)-1,0,COUNTIF(JT_UDT_CAP_MOD_PROGRAM_SCHED[Program Name],JT_UDT_CAP_MOD_STEP_ATT[@[Program Name]])))
Dynamic array formulas.

Cells with Data Validation
Cell	Allow	Criteria
B2:B14	List	=INDIRECT(SUBSTITUTE(A2," ","_"))

 

[Akuini]

Since you're using Excel 365, please check out this tutorial from Mynda Treacy:
Easy Dynamic Dependent Data Validation Two Ways