Get last date cleaned and post to another worksheet

[yoshaben]

Here is the table, it can have a max of 52 rows.
[TABLE="width: 536"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]Truck[/TD]
[TD]Date Cleaned[/TD]
[TD]Type Cleaning[/TD]
[TD]Next Cleaning Due[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]01/18/19[/TD]
[TD]Weekly[/TD]
[TD]01/25/19[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]01/18/19[/TD]
[TD]90 Day[/TD]
[TD]04/18/19[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]01/19/19[/TD]
[TD]Monthly[/TD]
[TD]02/18/19[/TD]
[/TR]
</tbody>[/TABLE]

So what I would like to do is take the last entry for truck 1, 5 or 55 etc. and create a sheet that shows when the next cleaning is due to be performed.
Where do I start? I'm thinking INDEX.MATCH but I'm not sure. Anyone willing to help?

 

[DanteAmor]

The truck 1 appears several times on the sheet?
If it only exists once, then you can use the vlookup formula

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Cell[/TD]
[TD]Formula[/TD]
[/TR]
[TR]
[TD]B2[/TD]
[TD]=vlookup(A2,Shee1!A:D,4,0)[/TD]
[/TR]
</tbody>[/TABLE]
Note: In cell A2 you put 1
Note: change Sheet1 by the name of your sheet with trucks and date

 

[yoshaben]

Thank you for the quick reply. Yes truck 1 and others may exist more than once. I need to capture the last date each truck was cleaned. So I guess my return would be truck with latest date should return the result.

My results would be truck 1 last done 1/19 truck 5 done 01/22 etc.
Again thank you for the help.

 

[Dave Patton]

Excel 2010
	A	B	C	D	E	F	G
1	Truck	Date Cleaned	Type Cleaning	Next Cleaning Due		Truck	Last
2	1	18-Jan-19	Weekly			1	21-Jan-19
3	3	18-Jan-19	90 Day
4	5	19-Jan-19	Monthly
5	1	21-Jan-19
6	3	22-Jan-19
7	5	23-Jan-19
5b

Cell Formulas
Range	Formula
G2	=AGGREGATE(14,6,B$2:B$100/(A$2:A$100=F2),1)

 

[DanteAmor]

If you do not have excel 2010

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px, align: center"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] , align: center"]G2[/TH]
[TD]=SUMPRODUCT(MAX((A2:A50=F2)*(B2:B50)))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]