INDEX MATCH with Multiple Criteria and Cannot Select Same Value Twice

[schwang]

I have a table that looks like the one below with Work Order # in descending order:

Employee Work Order #	Employee Date Worked	Employee Name	Employee Total Hours	Vehicle Work Order #	Vehicle Description	Vehicle Date Used	Vehicle Total Hours	Vehicle Operator
S11421	9/26/17	Jason	6	S11421	Pickup Truck	9/26/17	6
S11421	9/26/17	Mark	6	S11421	Dump Truck	10/10/17	2.5
S11421	10/10/17	Jason	4	S11421	Excavator	10/10/17	2.5
S11421	10/10/17	Frank	2.5
S11421	10/10/17	Austin	4

<tbody>
</tbody>

I want to enter a name in the Operator column. The operator can be any employee as long as he meets these qualifications:

• Same Work Order #
• Same Day Worked
• Worked at least as many hours as the vehicle was used
• Is not already an operator for another piece of equipment on that same day

I can use an Index Match combination to return a correct value that satisfies the first three equations, but I am not sure how to handle the last qualification of not having repeats. For example, in my formula, both the dump truck and excavator would return Jason as it is the first person who satisfies the first three qualifications.

If possible, I'd prefer to just use formulas to solve this and avoid VBA. Thanks in advance!