Calculating Last Date 's Price

Hi Dear Community ;

i need your kind help to create below formula ;

i have table A , which has agreement date per materials for prurchasing ,  and i want to create Table B , rule will be like that 

Table B will include only for per material last day's price and it's date as below , as you see i mentioned yelow remarked for table A that ones last day's price and on table B there are only this prices and their dates

Thanks in advance dear friends