Search matching 3 columns and Evaluate Problem

I post it on ozgrid.com but got no response after 2 days. I hope someone could help me here

Search matching 3 columns

I have 2 sheets

1 is the raw data and the other is the output

the raw consists of 5 columns

1 2 3 4 5
name type of time log date time shiftdate

the output should be


1 2 3 4 5
name time in time out time late shiftdate



now, im succesful in extracting the time in data but not the time out data. I've constructed a code where in it will make sure that the "Time OUT" "Shift Date" and Name should match then it would return the time corresponding to the "Time OUT". I've used if else statement.

The problem is, it will only look for the name and time out but it will disregard the date. It will search for the first row that will match the name and "Time OUT" not the date

How to solve this? thanks!


ProTimeOut Executes the command

If you have a better suggestion, feel free to tell me.
Thanks in advance!
VB:

Please Login or Register  to view this content.

Across the board I have come up with this. Match formula works in excel not in vba. pls help

VB:

Please Login or Register  to view this content.

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
I also want to implement this for errors:
VB:

Please Login or Register  to view this content.

This will work with variables in evaluate or other excel formula in vba.

Please Login or Register  to view this content.

This solved the problem:

Please Login or Register  to view this content.

thank marvinp for replying