Hlookup or index match?

[Noxqss38242]

BREAKDOWN-DOWNTIME.xls
	A	B
66	Indianapolis Occupied
67	UNIT	DAYS
68
69
70
71	Terminal Vendors Occupied
72	UNIT	Days at Vendor
73
74	20579	3
75
76	Road Repairs Occupied
77	UNIT	DAYS
78	20251	10
79	16854	7
80	16826	7
81	20361	2
82	20720	2
83	16912	2
84
85	Murray Shop Empty
86	UNIT	DAYS
87	20821	62
88	20497	53
89	20391	49
90	20255	49
91	16852	39
92	20515	39
93	20866	37
94	16807	36
95	20529	35
96	20525	34
Sheet1

Cell Formulas
Range	Formula
B74	B74	=TODAY()-R74
B87:B96,B78:B83	B78	=$J$1-R78

This is a sample of data I need to pull.
On another sheet, I want to pull the unit numbers of "Road Repairs Occupied" so it lists it:
20251
16854
16826
20361
20720
16912

Considering the index and match function are the same column, I'm having difficulties with that. Any solutions?
It also has to stop lookup up values (unit numbers) once a blank space is detected. As you can also see, sometimes they leave the blank in the first cell as is the case with "Terminal Vendors Occupied", if I were to search for that, I would want it to pull 20579 but stop after the first blank so to not pull the units for "Road Repairs Occupied".

Hopefully the formula is adjustable enough for me to change it to any condition, ie: "Murray Shop Empty", "Road Repairs Occupied", etc...


Thank you in advance!

 

[jasonb75]

That is not really a formula compatible format. This works, but I would be reluctant to call it a solution.
The formula in E66 finds the criteria specified, the formula in F66 counts the number of rows to return on the assumption that the layout is consistent with the example provided.
It only allows for one empty row at the end of each data block, any other empty rows will show zeros in the results.

Book1
	A	B	C	D	E	F
66	Indianapolis Occupied			Murray Shop Empty	85	11
67	UNIT	DAYS		UNIT	DAYS
68				20821	62
69				20497	53
70				20391	49
71	Terminal Vendors Occupied			20255	49
72	UNIT	Days at Vendor		16852	39
73				20515	39
74	20579	3		20866	37
75				16807	36
76	Road Repairs Occupied			20529	35
77	UNIT	DAYS		20525	34
78	20251	10
79	16854	7
80	16826	7
81	20361	2
82	20720	2
83	16912	2
84
85	Murray Shop Empty
86	UNIT	DAYS
87	20821	62
88	20497	53
89	20391	49
90	20255	49
91	16852	39
92	20515	39
93	20866	37
94	16807	36
95	20529	35
96	20525	34
Sheet3

Cell Formulas
Range	Formula
E66	E66	=MATCH(D66,A:A,0)
F66	F66	=IFERROR(MATCH("UNIT",INDEX(A:A,E66+2):INDEX(A:A,10000),0)-2,MATCH(1E+100,A:A)-E66)
D67:E78	D67	=IF(ROWS(D$67:D67)>$F$66,"",INDEX($A:$B,ROWS(D$67:D67)+$E$66,COLUMNS($D67:D67)))

 

[Noxqss38242]

Thank you!