Hiding Used Items in Drop Down List (multiple columns)

[alm395]

I have a spreadsheet I am working on. I was able to hide used items in the drop down list in column D, but I can't figure out how to carry it over to column H.

What would be optimal is:
1) to have the same exact formula/drop down list that is in D:D to be in H21:H23,
2) then to have any remaining member numbers automatically populate in H4:H19.

If option 2 is not recommended or whatever, then to have option 1 in H4:H19 and in H21:H23.

A1	B1	C1	D1	E1	F1	G1	H1
A2	SHIFT	ORDER	MEMBER #	MISC	VAC	TRAIN	WEDNESDAY
A3	D10	1	152				DAY OFF
A4	D10	2	160
A5	D10	3	165
A6	D10	4	168
A7	R2	5	170
A8
A9	E10	1	171
A10	E10	2	173
A11	E10	3	178
A12	E10	4	179
A13	E8	5	185
A14
A15	N10	1	186
A16	N10	2	187
A17	N8	3	193
A18
A19
A20							LOA
A21
A22
A23
A24
A25

<tbody>
</tbody>

The member list is on a separate tab called "Data List".

MEMBER #	INDEX	UNUSED
152		131R
160		150MH
165		159R
168		174MH
170		176R
171		177R
173		181MH
178		183MH
179		188MH
185		189R
186		192MH
187		198R
193		0
131R	15	0
150MH	16	0
159R	17	0
174MH	18	0
176R	19	0
177R	20	0
181MH	21	0
183MH	22	0
188MH	23	0
189R	24	0
192MH	25	0
198R	26	0
	27	0
	28	0
	29	0
	30	0

<tbody>
</tbody>

My formula in the "Index" column (B) is
=IF(COUNTIF(Lineup!$D:$D,'Data List'!A2),"",ROW())

My formula in the "Unused" column (C) is
=IF(ROW(A2)-ROW(A$2)+1>COUNT(B$2:B$51),"",INDEX(A:A,SMALL(B$2:B$52,1+ROW(A2)-ROW(A$2))))

Any help is appreciated.