If File1 has name in column A and age in column B, and File2 has name in column A and country in column B, here's what i would put in C1 of File1:
=IF(ISERROR(VLOOKUP(A1,[File2.xlsx]Sheet1!$A$1:$B$200,2,0)),"",VLOOKUP(A1,[File2.xlsx]Sheet1!$A$1:$B$200,2,0))
then copy down
Bookmarks