| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combining two ranges based on common a common value
I have two ranges like this:
Column 1 Column 2 Column 3 Column 4 Customer Name Price 1 Price 2 Price 3 ------------- ------- ------- ------- ABC Corporation 5.00 4.95 Apple Computers 5.50 5.25 Gifts Land 4.75 4.65 Sea Sure Products 5.00 4.75 Transparent Traders 5.25 5.00 Universal Enterprises 5.75 5.50 Column 8 Column 9 Customer Name Price 3 ------------- ------- Apple Computers 5.50 Sea Sure Products 5.00 Transparent Traders 5.25 How do I copy values under Price 3 in column 9 to Price 3 under Column 4 based on the matching values under Customer Name in Column 8 & column 1? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| combining two spreadsheets with a common field | Excel Discussion (Misc queries) | |||
| Combining spread sheets with common fields | Excel Discussion (Misc queries) | |||
| Common footer but not common margins please -(Page 1 of 2) etc | Excel Discussion (Misc queries) | |||
| combining data with a common cell value | Excel Discussion (Misc queries) | |||
| Combining rows of data that have one cell in common | Excel Discussion (Misc queries) | |||
![ahmed[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
