INDEX Formula that Indexes cells with specific text String

[Monica at Plastics]

I have a situation similar to this old thread here: https://www.mrexcel.com/forum/excel...-only-indexes-cells-specific-text-string.html

WE:	1/18/2019					46:00
	Day	Start	End	Lunch	Total
1/14	Monday	05:00	14:30	00:00	09:30
1/15	Tuesday	05:00	14:30	00:00	09:30
1/16	Wednesday	05:00	14:15	00:00	09:15
1/17	Thursday	06:00	14:30	00:30	08:00
1/18	Friday	06:00	11:30	00:00	05:30
1/13	Saturday	06:15	10:30	00:00	04:15
WE:	1/25/2019					18:15
	Day	Start	End	Lunch	Total
1/21	Monday	05:37	07:29	00:00	02:00		PTO	08:00	8
1/22	Tuesday	00:00	00:00	00:00	00:00		PTO	08:00	8
1/23	Wednesday	00:00	00:00	00:00	00:00		PTO	08:00	8
1/24	Thursday	05:50	14:30	00:30	08:15
1/25	Friday	05:51	13:54	00:00	08:00
1/19	Saturday

<tbody>
</tbody>

I want to use index but when it finds the word PTO I want it to return the date.

 

[Monica at Plastics]

Thank you soooo much for all your help!!!