Index/Match of Max If

[Noz2k]

Essentially I have some data that is like the below, in a sheet called 'Data':

C1	01/01/2018	TypeA
C2	04/01/2018	TypeB
C3	23/12/2017	TypeA
C2	12/01/2018	TypeC
C1	19/12/2017	TypeC

<tbody>
</tbody>

What I want to return in a new sheet for each ID, is the latest date, and the corresponding Type, so the end result would look like below

C1	01/01/2018	TypeA
C2	12/01/2018	TypeC
C3	23/12/2017	TypeA

<tbody>
</tbody>

I can get the latest date using the below formula, but do not not how to get the value in the corresponding column C for that row

{=MAX(IF('Data'!A:A=A2,'Data'!B:B))}

 

[Special-K99]

=INDEX(Data!C:C,MATCH(1,(Sheet1!B1=DataB:B)*(Sheet1!A1=Data!A:A),0),1)
Array formula, use Ctrl-Shift-Enter

where Sheet1 is your results sheet.

 

[Noz2k]

Awesome, meets my requirements thank you.

and helped me work out how to do it if I didn't already have the max data in column B.

Thanks,