Getting the latest date

[CHOI CL]

have two sheets > SALES! & stocks!
date & code in SALES!$C$6:$C$5088 & SALES!$E$6:$E$5088 respectively
date out & item code in stocks!$C$59$:$C$1887 & stocks!F$59:$F$1887 respectively

once item code scanned into SALES!$E$6:$E$5088
the current date will appear on stocks!$C$59$:$C$1887 with this formula (**for item stocks!F170)
=INDEX(SALES!$C$5:$C$5087,MATCH(stocks!F170,SALES!$E$5:$E$5087,0))

but,let's say that item stocks!F170 have 4pcs and sold on different dates
how do i generate the updated date for the item?

did tried this
=INDEX(MAX(SALES!$C$5:$C$5087,MATCH(stocks!F170,SALES!$E$5:$E$5087,0)))
but it only give out the latest date in SALES!$C$6:$C$5088
not the lates date sold based on that item

please help and advance thank you

 

[RasGhul]

Can you use this?

Book1
	C	D	E	F
1	Date			Item SKU
2	01-03-19			item1
3	02-03-19			item2
4	03-03-19			item3
5	04-03-19			item1
6	05-04-19			item2
7	06-04-19			item3
8	07-04-19			item5
9	08-04-19			item5
10	09-04-19			item5
11	10-05-19			item2
12	11-05-19			item3
13	12-05-19			item1
14	13-05-19			item2
15	14-05-19			item3
16	15-05-19			item1
Stocks

Book1
	E	F
1	Item SKU	Latest Date
2	item1	15-05-19
3	item2	13-05-19
Sales

Cell Formulas
Range	Formula
F2	{=MAX(IF(Stocks!$F$2:$F$16=Sales!E2,Stocks!$C$2:$C$16))}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[CHOI CL]

thank you for replying

from your solution
{=MAX(IF(Stocks!$F$2:$F$16=Sales!E2,Stocks!$C$2:$C$16))}


i used this instead because i wanted the latest date
to return in stocks!$C$59$:$C$1887 based on the item code in stocks!F$59:$F$1887

so this is the formula
=ArrayFormula(MAX(IF(SALES!$E$6:$E$5088=stocks!!F170,SALES!$C$6:$C$5088)))
**i'm using Google Sheet**

but return back as #ERROR!(formula parse error)