Vlook UP

I have two sheets, sheet 1 and sheet2.In sheet 1,I need to do vloopup on I and J column.

In sheet 2, C column, which have some repeated material number . how to v.look-up to the latest one . (For e.g In the attachment, i have same material number in different date , 02-jan and 01-april but i want the April date and cost to look up .)