returning next highest time in list

[Spikenaylor]

I have a list of date and times which an item was entered into a fridge

the fridge has a humidity and temperature sensor, both could indicate individually that the fridge has gone out of spec and then come back in.

I have calculated a list of times the fridge is completely back in spec

I now need to show in column B for each item entered, the time the fridge has completely come back in spec.

A	B	C	Z
Time item into fridge	Time fridge fully back in spec for this item, (what the value should be)		Calculated times fridge back in spec
10:47	11:01		11:01
11:06	11:24		11:24
11:36	11:57		11:57
12:03	12:44		12:44
12:25	12:44		13:24
12:52	13:24
13:04	13:24

<tbody>
</tbody>

It is basically get the next highest time in Z for the value in A

just struggling to get it to work

I seem to just continually get one result of 12:44, when there should be two results of 12:44

any pointers greatly received
many thanks for looking

 

[Eric W]

Consider:

	A	B	C	Z	AA
1	A	B	C	Z
2	Time item into fridge	Time fridge fully back in spec for this item, (what the value should be)		0
3	10:47	11:01		11:01
4	11:06	11:24		11:24
5	11:36	11:57		11:57
6	12:03	12:44		12:44
7	12:25	12:44		13:24
8	12:52	13:24
9	13:04	13:24

<tbody>
</tbody>

Sheet4​

Worksheet Formulas Cell Formula B3 =INDEX($Z$3:$Z$8,MATCH(A3,$Z$2:$Z$7)) <tbody> </tbody>

<tbody>
</tbody>

 

[Spikenaylor]

Many thanks
just a simple addition to the top row

thanks again

 

[Eric W]

That's all it takes, also notice that the 2 ranges are offset by 1 row.

Glad to help.