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