match&max (excel2003)

hi all,

in the attached file, I need a formula help, that will do the following, match name and no in sheet1 with name and no in sheet2, if match exist, then replace inidate (col d) in sheet1 for the matched name and no with the maximum date from stdate (col g) in sheet2.