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.

Tran Type

Add Date/Time

ITRN Source Type

ITRN Create Date

ITRN From Location

ITRN To Location

SKU

Count

Qty

Move

5/31/19 5:28 AM

PICKING

43616

S1723

SS46

1030901

2

2

CLOCK IN

CLOCK OUT

Move

5/31/19 5:30 AM

PICKING

43616

S1819

SS46

1161217

2

2

Alexander, Petrina

5/31/2019

Add Punch

5/31/19 5:02 AM

5/31/19 5:44 AM

5:02AM

Move

5/31/19 5:36 AM

PICKING

43616

S3127

SS46

1030903

4

4

Alexander, Petrina

5/31/2019

Add Punch

5/31/19 5:45 AM

5/31/19 5:59 AM

5:24AM

2

Move

5/31/19 5:44 AM

PICKING

43616

N3306

SS46

623778

4

4

Alexander, Petrina

5/31/2019

Add Punch

5/31/19 6:00 AM

5/31/19 7:44 AM

5:33AM

3

Move

5/31/19 5:48 AM

PICKING

43616

S3504

SS46

712897

4

4

Alexander, Petrina

5/31/2019

Add Punch

5/31/19 7:45 AM

5/31/19 9:14 AM

7:32AM

4

Move

5/31/19 5:51 AM

PICKING

43616

S3206

SS46

753010

4

4

Alexander, Petrina

5/31/2019

Add Punch

5/31/19 9:15 AM

5/31/19 9:59 AM

9:08AM

5

Move

5/31/19 5:54 AM

PICKING

43616

S3435

SS46

828917

2

2

Alexander, Petrina

5/31/2019

Add Punch

5/31/19 10:00 AM

5/31/19 10:14 AM

9:56AM

6

Move

5/31/19 5:54 AM

PICKING

43616

S3435

SS46

828917

2

2

Alexander, Petrina

5/31/2019

Add Punch

5/31/19 10:15 AM

5/31/19 11:14 AM

10:04AM

7

Move

5/31/19 5:58 AM

PICKING

43616

N1816

SS46

852883

2

2

Alexander, Petrina

5/31/2019

Add Punch

5/31/19 12:15 PM

5/31/19 12:59 PM

12:05PM

8

Move

5/31/19 5:58 AM

PICKING

43616

N1816

SS46

852883

2

2

Alexander, Petrina

5/31/2019

Add Punch

5/31/19 1:00 PM

5/31/19 1:59 PM

12:56PM

9

Move

5/31/19 6:02 AM

PICKING

43616

S3314

SS46

852876

2

2

Alexander, Petrina

5/31/2019

Add Punch

5/31/19 2:00 PM

5/31/19 2:59 PM

1:51PM

10

Move

5/31/19 6:04 AM

PICKING

43616

S3525

SS46

852886

2

2

Alexander, Petrina

5/31/2019

Add Punch

5/31/19 3:00 PM

5/31/19 3:00 PM

3:00PM

11

Move

5/31/19 6:08 AM

PICKING

43616

S3125

SS46

876299

2

2

<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>
</tbody>

 

[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 ?