Match Column and copy to cell Column D

[Jeffrey Yau]

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/tutorial...f2-59b545ced4fd/c--email-with-attachment.aspx

 

[Ashish Mathur]

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

in message news:[email protected]...