Match Column and copy to cell Column D
 

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

Match Column and copy to cell Column D
 

Hi,

Yu may try the VLOOKUP function. Please read up on the same in MS Excel's
Help menu

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Jeffrey Yau" wrote in message ...
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