index match using column headers

[Aqusmacro]

Hi I managed to get Index match to work with the headers using rows
If I click on data validation in B34 and choose a value, C34 data validation list is available dependent of what is in B34.
D34 shows the formula so you can see what I used. This formula is pasted in the data validition source for C34

I only showed part of the list as it is over 50 long therefore I would prefer doing the same thing but having the list in the columns like the bottom part of the sheet.
Is there a way to use columns as headers instead of rows?

Thanks

transactions.xlsx
	B	C	D	E	F	G	H	I	J
34	Auto transport	Auto Fuel	INDEX($B$37:$G$44,,MATCH($B$34,$B$36:$G$36,0))
35
36	Auto transport	Bank Fee	Bills	Alcohol & Bars	Cellular	Clothing
37	Auto 2		hydro
38	Auto Fuel		cell
39	Auto Insurance		bell
40	Auto Other
41	Fuel auto 2
42	Payment
43	Porsche
44	Porsche Fuel
45
46	Auto transport	Auto 2	Auto Fuel	Auto Insurance	Auto Other	Fuel auto 2	Payment	Porsche	Porsche Fuel
47	Bank Fee
48	Bills	hydro	cell	bell
49	Alcohol & Bars
50	Cellular
51	Clothing
Sheet1

Cells with Data Validation
Cell	Allow	Criteria
B34	List	=$B$36:$G$36
C34	List	=INDEX($B$37:$G$44,,MATCH($B$34,$B$36:$G$36,0))

 

[Aqusmacro]

Good morning I tried searching everywhere and can't find an answer for this.
Any help would be appreciated. Or knowing if it is even possible
Thanks

 

[AlanY]

similar to what you're doing

Book1
	B	C	D	E	F	G	H	I	J
34	Bills	hydro	INDEX($B$37:$G$44,,MATCH($B$34,$B$36:$G$36,0))
35
36	Auto transport	Bank Fee	Bills	Alcohol & Bars	Cellular	Clothing
37	Auto 2		hydro
38	Auto Fuel		cell
39	Auto Insurance		bell
40	Auto Other				X
41	Fuel auto 2
42	Payment
43	Porsche
44	Porsche Fuel
45
46	Bills	hydro	INDEX($B$48:$J$53,MATCH($B$46,$B$48:$B$53,0),)
47
48	Auto transport	Auto 2	Auto Fuel	Auto Insurance	Auto Other	Fuel auto 2	Payment	Porsche	Porsche Fuel
49	Bank Fee
50	Bills	hydro	cell	bell
51	Alcohol & Bars
52	Cellular				X
53	Clothing
54
Sheet1

Cells with Data Validation
Cell	Allow	Criteria
B34	List	=$B$36:$G$36
C34	List	=INDEX($B$37:$G$44,,MATCH($B$34,$B$36:$G$36,0))
B46	List	=$B$48:$B$53
C46	List	=INDEX($C$48:$J$53,MATCH($B$46,$B$48:$B$53,0),)

 

[Aqusmacro]

similar to what you're doing

Book1
	B	C	D	E	F	G	H	I	J
34	Bills	hydro	INDEX($B$37:$G$44,,MATCH($B$34,$B$36:$G$36,0))
35
36	Auto transport	Bank Fee	Bills	Alcohol & Bars	Cellular	Clothing
37	Auto 2		hydro
38	Auto Fuel		cell
39	Auto Insurance		bell
40	Auto Other				X
41	Fuel auto 2
42	Payment
43	Porsche
44	Porsche Fuel
45
46	Bills	hydro	INDEX($B$48:$J$53,MATCH($B$46,$B$48:$B$53,0),)
47
48	Auto transport	Auto 2	Auto Fuel	Auto Insurance	Auto Other	Fuel auto 2	Payment	Porsche	Porsche Fuel
49	Bank Fee
50	Bills	hydro	cell	bell
51	Alcohol & Bars
52	Cellular				X
53	Clothing
54
Sheet1

Cells with Data Validation
Cell	Allow	Criteria
B34	List	=$B$36:$G$36
C34	List	=INDEX($B$37:$G$44,,MATCH($B$34,$B$36:$G$36,0))
B46	List	=$B$48:$B$53
C46	List	=INDEX($C$48:$J$53,MATCH($B$46,$B$48:$B$53,0),)

exactly what I needed. Tried so many ways and couldn't figure out. Your solution worked great. thanks for replying

 

[AlanY]

exactly what I needed. Tried so many ways and couldn't figure out. Your solution worked great. thanks for replying

you're welcome