Excel Problem

[camdenwill1]

I am trying to find the coresponding code that goes along with the clock in and clock out times. I have tried everything and cannot find a solution. Please help. For example< I need the times between 5:45 Am and 5:59 Am to correspond with code 2. The formula I have used is =LOOKUP(2,1/(E4<=A4:A9)/(F4>=A4:A9),K4) but it does not bring up the right code.[TABLE="width: 1912"]
<colgroup><col><col><col span="2"><col><col><col><col><col span="2"><col><col><col><col><col><col span="2"><col><col><col><col></colgroup><tbody>[TR]
[TD]Tran Type[/TD]
[TD]Add Date/Time[/TD]
[TD]ITRN Source Type[/TD]
[TD]ITRN Create Date[/TD]
[TD]ITRN From Location[/TD]
[TD]ITRN To Location[/TD]
[TD]SKU[/TD]
[TD]Count[/TD]
[TD]Qty[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Move[/TD]
[TD="align: right"]5/31/19 5:28 AM[/TD]
[TD]PICKING[/TD]
[TD="align: right"]43616[/TD]
[TD]S1723[/TD]
[TD]SS46[/TD]
[TD]1030901[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]CLOCK IN[/TD]
[TD]CLOCK OUT[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Move[/TD]
[TD="align: right"]5/31/19 5:30 AM[/TD]
[TD]PICKING[/TD]
[TD="align: right"]43616[/TD]
[TD]S1819[/TD]
[TD]SS46[/TD]
[TD]1161217[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD]Alexander, Petrina[/TD]
[TD]5/31/2019[/TD]
[TD]Add Punch[/TD]
[TD="align: right"]5/31/19 5:02 AM[/TD]
[TD="align: right"]5/31/19 5:44 AM[/TD]
[TD][/TD]
[TD][/TD]
[TD]5:02AM[/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Move[/TD]
[TD="align: right"]5/31/19 5:36 AM[/TD]
[TD]PICKING[/TD]
[TD="align: right"]43616[/TD]
[TD]S3127[/TD]
[TD]SS46[/TD]
[TD]1030903[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD][/TD]
[TD]Alexander, Petrina[/TD]
[TD]5/31/2019[/TD]
[TD]Add Punch[/TD]
[TD="align: right"]5/31/19 5:45 AM[/TD]
[TD="align: right"]5/31/19 5:59 AM[/TD]
[TD][/TD]
[TD][/TD]
[TD]5:24AM[/TD]
[TD][/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Move[/TD]
[TD="align: right"]5/31/19 5:44 AM[/TD]
[TD]PICKING[/TD]
[TD="align: right"]43616[/TD]
[TD]N3306[/TD]
[TD]SS46[/TD]
[TD]623778[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD][/TD]
[TD]Alexander, Petrina[/TD]
[TD]5/31/2019[/TD]
[TD]Add Punch[/TD]
[TD="align: right"]5/31/19 6:00 AM[/TD]
[TD="align: right"]5/31/19 7:44 AM[/TD]
[TD][/TD]
[TD][/TD]
[TD]5:33AM[/TD]
[TD][/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Move[/TD]
[TD="align: right"]5/31/19 5:48 AM[/TD]
[TD]PICKING[/TD]
[TD="align: right"]43616[/TD]
[TD]S3504[/TD]
[TD]SS46[/TD]
[TD]712897[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD][/TD]
[TD]Alexander, Petrina[/TD]
[TD]5/31/2019[/TD]
[TD]Add Punch[/TD]
[TD="align: right"]5/31/19 7:45 AM[/TD]
[TD="align: right"]5/31/19 9:14 AM[/TD]
[TD][/TD]
[TD][/TD]
[TD]7:32AM[/TD]
[TD][/TD]
[TD="align: right"]4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Move[/TD]
[TD="align: right"]5/31/19 5:51 AM[/TD]
[TD]PICKING[/TD]
[TD="align: right"]43616[/TD]
[TD]S3206[/TD]
[TD]SS46[/TD]
[TD]753010[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD][/TD]
[TD]Alexander, Petrina[/TD]
[TD]5/31/2019[/TD]
[TD]Add Punch[/TD]
[TD="align: right"]5/31/19 9:15 AM[/TD]
[TD="align: right"]5/31/19 9:59 AM[/TD]
[TD][/TD]
[TD][/TD]
[TD]9:08AM[/TD]
[TD][/TD]
[TD="align: right"]5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Move[/TD]
[TD="align: right"]5/31/19 5:54 AM[/TD]
[TD]PICKING[/TD]
[TD="align: right"]43616[/TD]
[TD]S3435[/TD]
[TD]SS46[/TD]
[TD]828917[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD]Alexander, Petrina[/TD]
[TD]5/31/2019[/TD]
[TD]Add Punch[/TD]
[TD="align: right"]5/31/19 10:00 AM[/TD]
[TD="align: right"]5/31/19 10:14 AM[/TD]
[TD][/TD]
[TD][/TD]
[TD]9:56AM[/TD]
[TD][/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Move[/TD]
[TD="align: right"]5/31/19 5:54 AM[/TD]
[TD]PICKING[/TD]
[TD="align: right"]43616[/TD]
[TD]S3435[/TD]
[TD]SS46[/TD]
[TD]828917[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD]Alexander, Petrina[/TD]
[TD]5/31/2019[/TD]
[TD]Add Punch[/TD]
[TD="align: right"]5/31/19 10:15 AM[/TD]
[TD="align: right"]5/31/19 11:14 AM[/TD]
[TD][/TD]
[TD][/TD]
[TD]10:04AM[/TD]
[TD][/TD]
[TD="align: right"]7[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Move[/TD]
[TD="align: right"]5/31/19 5:58 AM[/TD]
[TD]PICKING[/TD]
[TD="align: right"]43616[/TD]
[TD]N1816[/TD]
[TD]SS46[/TD]
[TD]852883[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD]Alexander, Petrina[/TD]
[TD]5/31/2019[/TD]
[TD]Add Punch[/TD]
[TD="align: right"]5/31/19 12:15 PM[/TD]
[TD="align: right"]5/31/19 12:59 PM[/TD]
[TD][/TD]
[TD][/TD]
[TD]12:05PM[/TD]
[TD][/TD]
[TD="align: right"]8[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Move[/TD]
[TD="align: right"]5/31/19 5:58 AM[/TD]
[TD]PICKING[/TD]
[TD="align: right"]43616[/TD]
[TD]N1816[/TD]
[TD]SS46[/TD]
[TD]852883[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD]Alexander, Petrina[/TD]
[TD]5/31/2019[/TD]
[TD]Add Punch[/TD]
[TD="align: right"]5/31/19 1:00 PM[/TD]
[TD="align: right"]5/31/19 1:59 PM[/TD]
[TD][/TD]
[TD][/TD]
[TD]12:56PM[/TD]
[TD][/TD]
[TD="align: right"]9[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Move[/TD]
[TD="align: right"]5/31/19 6:02 AM[/TD]
[TD]PICKING[/TD]
[TD="align: right"]43616[/TD]
[TD]S3314[/TD]
[TD]SS46[/TD]
[TD]852876[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD]Alexander, Petrina[/TD]
[TD]5/31/2019[/TD]
[TD]Add Punch[/TD]
[TD="align: right"]5/31/19 2:00 PM[/TD]
[TD="align: right"]5/31/19 2:59 PM[/TD]
[TD][/TD]
[TD][/TD]
[TD]1:51PM[/TD]
[TD][/TD]
[TD="align: right"]10[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Move[/TD]
[TD="align: right"]5/31/19 6:04 AM[/TD]
[TD]PICKING[/TD]
[TD="align: right"]43616[/TD]
[TD]S3525[/TD]
[TD]SS46[/TD]
[TD]852886[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD]Alexander, Petrina[/TD]
[TD]5/31/2019[/TD]
[TD]Add Punch[/TD]
[TD="align: right"]5/31/19 3:00 PM[/TD]
[TD="align: right"]5/31/19 3:00 PM[/TD]
[TD][/TD]
[TD][/TD]
[TD]3:00PM[/TD]
[TD][/TD]
[TD="align: right"]11[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Move[/TD]
[TD="align: right"]5/31/19 6:08 AM[/TD]
[TD]PICKING[/TD]
[TD="align: right"]43616[/TD]
[TD]S3125[/TD]
[TD]SS46[/TD]
[TD]876299[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Gerald Higgins]

Hi, welcome to the board.

I have tried everything and cannot find a solution

There is therefore no solution ?

Or maybe we can find one.

Help us out with your data please.

I need the times between 5:45 Am and 5:59 Am . . .

Which times ?
Your data has 4 columns of time data, all dfferent.

... to correspond with code 2

What does this mean ?
What is code 2 ?
I see no reference to anything like code 2 in your data.

The formula I have used is =LOOKUP(2,1/(E4<=A4:A9)/(F4>=A4:A9),K4)

This would be useful information if we knew which columns your data was in.
But we don't.
I'm guessing column A is NOT the column headed "Tran Type", which implies that column A is not even shown in your data.
So if that's the case, what does column A look like ?