ok i have two excel files, I want to add two new colums to one ov the files, both colums will be numeric.

I want it so that if names are equal in one file to the other I can retrive info from the main file.

Ther will be a case ov duplicate names, the main file contains 5000rows so doing everythin manually is gonna take me a long time....is ther a code I can write and use,

Even if I got the majority and it highlighted the duplicates?
anyways if anyone knows be a great help,il check back for replies.if ya need more info i can provide. thanks