Dropdown list with multiple dependencies

[usurrao]

Good afternoon
I am trying to set up drop down list in adjacent columns that are dependent on the selection in the previous column. I have tried using samples that were listed in the discussion board but I am obviously doing something wrong and get an error message. I am not comfortable with VBA so a formula would help. I tried using DataValidation with a Match/Index formula but it did not work.
I have the lists located on a separate sheet and these values will be used across many sheets in the same workbook. I cannot use named ranges as my data has a lot of control characters (&,-,/) and spaces.

Primary

XYZ Outside

ZAC Inside

ABC-CDE

<tbody>
</tbody><colgroup><col></colgroup>

Prim_2_Sec	Secondary
ABC-CDE	27-ME Carp
ABC-CDE	27-XE Plum
ABC-CDE	57-LM S&htm
ABC-CDE	CU-LPE 114&8
XYZ Outside	IrnW/Z 1920
XYZ Outside	Gar 23&44
XYZ Outside	AB-Lcl/77i
ZAC Inside	Ex N/U&S
ZAC Inside	MBrk/St 22-IN

<tbody>
</tbody><colgroup><col><col></colgroup>

Sec_2_Third	Third
27-ME Carp	WVB 2/1
27-ME Carp	123 A/B&X
27-XE Plum	456 AB&C
57-LM S&htm	ZAC 123
57-LM S&htm	ZAC 456
57-LM S&htm	ZAC 711
AB-Lcl/77i	WVB 2/1
AB-Lcl/77i	123 A/B&X
CU-LPE 114&8	ZAC 123
CU-LPE 114&8	ZAC 456
CU-LPE 114&8	ZAC 711
Ex N/U&S	ZAC 456
Ex N/U&S	ZAC 711
Gar 23&44	ZAC 123
Gar 23&44	ZAC 456
Gar 23&44	ZAC 711
IrnW/Z 1920	456 AB&C
MBrk/St 22-IN	WVB 2/1
MBrk/St 22-IN	WVB 4/1

<tbody>
</tbody><colgroup><col><col></colgroup>

Any help welcome. I did convert each column to a new table.

Cheers, US