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?