| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return text in Column A if Column B and Column K match | Excel Worksheet Functions | |||
| Match a cell to something in a column and return a YES | Excel Worksheet Functions | |||
| Display missing Part Number if Column A does not match column B | Excel Worksheet Functions | |||
| Match Header...Copy Column | Excel Discussion (Misc queries) | |||
| Need rows in Column A removed if they fully or partially match with any Column B row | Excel Discussion (Misc queries) | |||
Threaded Mode
