| 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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combining two ranges based on common a common value
try this in col 4, D2 and copy down
=IF(ISNA(VLOOKUP(A2,$H$2:$I$4,2,0)),"",VLOOKUP(A2, $H$2:$I$4,2,0)) -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis Am not a greek but an ordinary user trying to assist another "ahmed" wrote: 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combining two ranges based on common a common value
Assuming header row try this in D2 (4th Col)
=VLOOKUP(A2,H:I,2,False) and copy down... "ahmed" wrote: 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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combining two ranges based on common a common value
This worked fine. Thank you for your time.
--- ahmed Francis wrote: try this in col 4, D2 and copy down =IF(ISNA(VLOOKUP(A2,$H$2:$I$4,2,0)),"",VLOOKUP(A2, $H$2:$I$4,2,0)) |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combining two ranges based on common a common value
Hi Ahmed
Thank you for your feedback. Am glad that this work for you Appreciate that you click on the Yes button below in order that others could find the answer to similar case like yours in the future -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis Am not a greek but an ordinary user trying to assist another "ahmed" wrote: This worked fine. Thank you for your time. --- ahmed Francis wrote: try this in col 4, D2 and copy down =IF(ISNA(VLOOKUP(A2,$H$2:$I$4,2,0)),"",VLOOKUP(A2, $H$2:$I$4,2,0)) |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combining two ranges based on common a common value
Hi Francis
I am sorry that I couldn't find the Yes button in your messages. By the way, my news reader is Mozilla Thunderbird. Thanks. --- ahmed Francis wrote: Hi Ahmed Thank you for your feedback. Am glad that this work for you Appreciate that you click on the Yes button below in order that others could find the answer to similar case like yours in the future |
| Reply |
| 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)
Linear Mode
