I am looking for a method to do on my Excel, to compare the "rate" in column C

I have 2 similar excel 1 & 2 file, both of the file are as follow:

Column A: with a list of country code + area code, such as 55, 5545, 5511, etc

Column B: Country Name
Column C: Rate ($)

I would like to match by the country code, if the code in Excel 1 Column A same as the code in Excel 2 Column A , then copy the rate (Column C) in Excel 2 into Excel 1 Column D.

Hope this make sense, and understand.

Thank you very much.

Jeffrey



EggHeadCafe - Software Developer Portal of Choice
C# Email With Attachment / Upload / Validation
http://www.eggheadcafe.com/tutorials...ttachment.aspx