How to Create Multiple Dependent Drop-Down Lists (on Every Row)?

[Lacan]

Hello Guys,

My originally table has 5 columns and 2390 rows.

This is just a sample table to explain the goal thats how to create Create Multiple Dependent Drop-Down Lists (on Every Row)?

Without VBA and with simple fuid efficiency formulas please let me know how to overtake this challenge?

Additional information please let me know.

Thank you very much.

Novo Folha de Cálculo do Microsoft Excel.xlsx
	B	C	D	E	F	G	H	I	J	K	L	M
2	MAIN TABLE						CODE
3	CODE	CENTER	CITY	SPECIALITY	NAME		AA 11		CENTER	CITY	SPECIALITY	NAME
4	AA 11	ALPHA	DENVER	NURSE	JOHN				(opens drop down list based on cell H3)	(opens drop down list based on cell J4)	(opens drop down list based on cell K4)	(opens drop down list based on cell L4)
5	AA 11	ALPHA	DENVER	NURSE	PETER				(opens drop down list based on cell H3)	(opens drop down list based on cell J5)	(opens drop down list based on cell K5)	(opens drop down list based on cell L5)
6	AA 11	CREATIVE	DENVER	PHYSICIAN	ANDREA				(opens drop down list based on cell H3)	…	…	…
7	BB 13	SIC	COLORADO	PHYSICIAN	OLGA				…
8	BB 13	SIC	COLORADO	NURSE	GABY
9	BB 13	TVI	COLORADO	TECHNICIAN	FAISA
10	CC 20	RT1	DALLAS	TECHNICIAN	ERBA
11	CC 20	RTP2	DALLAS	NURSE	PURA
12	DD 02	FOX	YORK	TECHNICIAN	EURO
13	EE 05	HOLLYWOOD	DUBLIN	PHYSICIAN	YGOR		CODE
14	EE 05	HOLLYWOOD	DUBLIN	PHYSICIAN	JAINE		BB 13
15	EE 05	HOLLYWOOD	DUBLIN	NURSE	LYON				CENTER	CITY	SPECIALITY	NAME
16	EE 05	FOX T	DUBLIN	LAWYER	JASY				(opens drop down list based on cell H14)	(opens drop down list based on cell J16)	(opens drop down list based on cell K16)	(opens drop down list based on cell L16)
17	FF 07	JAM	MADRID	LAWYER	JASUS				(opens drop down list based on cell H14)	(opens drop down list based on cell I17)	(opens drop down list based on cell K17)	(opens drop down list based on cell L17)
18	FF 89	JAM 2	BARCELONA	NURSE	OSCAR				(opens drop down list based on cell H14)	…	…	…
19	FF 90	ANK	HUELVA	POLICE	FILIPE				…
20	FF 91	ANK 4	FARO	POLICE	JACQUELINE
21	FF 92	ANK 5	LONDON	PHYSICIAN	ANTERD
22	FF 92	ANK 5	PORTO	TECHNICIAN	SOVIET
23	FF 92	RTL	PORTO	NURSE	LEVIS
24	GG 24	RTL 2	LUX	POLICE	C17
25	GG 24	RTL 3	LUX	PHYSICIAN	FLY
26	…
27
Folha1

 

[Lacan]

...

 

[Lacan]

...