Find closest time value based on multiple criteria

Hi all,

I hope you can help me figure out a formula for this.

Attached is my data.

In COLUMN T on Sheet 1 tab, I need to get the closest time on COLUMN Z on Sheet 0 tab using COLUMNS C and N on Sheet 1 tab.

I am hoping someone can help!

Thank you.

Hello AVK,

i want to match the closest SIGN_IN time of the person (column A) in SHEET 1 based on the time indicated in COLUMN N

If you look at the attachment, the result i would like to see in sheet 1 column t cell 'T4' is cell 'Z4' on the first sheet. criteria is sheet 1 columns C and N and look up value is column Z on the first sheet.

i hope this makes sense.

thank you!

Hello AVK,

Have you hadva chance to look into this?

Appreciate the help in advance!

Thanks!

Surely not Z4 as the dates are different? Z21 is a match on Date & Time

Please add some results to your posted file

Hi,

Thank you all for looking into this.

Just to make the query clearer:

Sheet 01 - employee schedule
Sheet 02 - sign in and sign out time of the employee

GOAL: to check based on signin and signout how much the deviate from their schedule.

Sample:

Sheet 01 row 3 - employee ended the lunch at 1630; looking at sheet 02 closest signin time was cell Z9 at 1645.

Need to identify formula to reflect the result with multiple employees and dates as reference.

Thank you.

Thank you AVK. I use the EMP_ID or EMP_SHORT_NAME as the unique reference field.