Copying sheet data

NEW.xls

Dear all,

I have attached excel file for reference . I need simple thing do with excel sheet. I have 2 sheet

1) 1sheet -> country , location, code
2) 2 sheet-> latitude, longitude, code.

But in actually I have 2 different excel sheet. where data are seprated . for understanding i put in 1 sheet.

This what i want in second sheet i would like to place Country & location based on code value.

If Country_code in sheet 2 matches with country_code in sheet1 place corresponding country & location in sheet2 else put string "NA"
NA represent country code not avilable

In sheet 2 , There are Country code duplicate ,
IF country code duplicate found remove duplicate record & place new record in Sheet 3 without duplicate.

Please let me know how can do this

Country_code.xlsxCounty_latitude.xlsx

I have attached 2 excel file for reference but i could not able apply formula . can you check what mistake done in excel