Combining two ranges based on common a common value

A

ahmed

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?
 
F

Francis

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
 
S

Sheeloo

Assuming header row try this in D2 (4th Col)
=VLOOKUP(A2,H:I,2,False)
and copy down...
 
F

Francis

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
 
A

ahmed

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top