Get last date cleaned and post to another worksheet

[yoshaben]

Here is the table, it can have a max of 52 rows.

Truck	Date Cleaned	Type Cleaning	Next Cleaning Due
1	01/18/19	Weekly	01/25/19
3	01/18/19	90 Day	04/18/19
5	01/19/19	Monthly	02/18/19

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

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

Cell	Formula
B2	=vlookup(A2,Shee1!A:D,4,0)

<tbody>
</tbody>

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

Formulas Cell Formula G2 =SUMPRODUCT(MAX((A2:A50=F2)*(B2:B50))) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>