Automatically fill cell according to other cell's content.

[sb003848]

Here is the situation

	A	B	C
1	Unit #	Hour meter (Start)	Hour meter (End)
2	1111	0000	0025
3	2222	0000	0125
4	3333	0000	0247
5	4444	0000	0006
6	1111	0025 (search for last content for 1111)	0039
7	1111	0039 (search for last content for 1111)	0048
8	2222	0125 (search for last content for 2222)	0158

<tbody>
</tbody>

What you can see is I'm trying to know the formula needed in column B in order to, according to the unit # entered into row A, automatically search for the last entry for the same unit # and get the info from row C.

Can that be done ?

Thanks in advance.

 

[Takae]

It effects from B3.
B3=IFERROR(OFFSET(C3,-(ROWS($A$2:A2)+1-MATCH(1,INDEX(0/($A$2:A2=A3),0),1)),0),"0000")