VBA/Vlookup/Idex match

I have a workbook with two worksheet. Please help me out with anything Vlookup/Index match, VBA etc..

On sheet1 I have column A= item number, column G=price and column M=location. On sheet2 I have column A= item number, column D=-lot, column G=price and column M=location.

But on sheet2 on Column A has same item number with multiple rows with different lot on column D. is there a way that can be done in VBA/Vlookup anything that look up the oldest lot and copy price and location to sheet1? Help me out please. I spent hours pretty much of my work day search each item copy and paste. Attachment is an example



Thanks in advance.