Monica at Plastics
New Member
- Joined
- Apr 26, 2019
- Messages
- 12
I have a situation similar to this old thread here: https://www.mrexcel.com/forum/excel...-only-indexes-cells-specific-text-string.html
<tbody>
</tbody>
I want to use index but when it finds the word PTO I want it to return the date.
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.
Last edited by a moderator: