Need to match cols then move data to new col.

Closed
cmboykin - Jul 15, 2010 at 08:29 AM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Jul 18, 2010 at 09:29 AM
Hello,

I have a excel spreadsheet with has three columns.

Code Code Price
01996 0003T $0.00
10021 0008T $0.00
10022 00100 $0.00
10040 00102 $0.00
10060 00103 $0.00
10061 00104 $0.00
10080 0010T $0.00
10081 00120 $0.00
10120 00124 $0.00
10121 00126 $0.00
10140 00140 $0.00
10160 00142 $0.00
10180 00144 $0.00
11000 00145 $0.00
11001 00147 $0.00
11004 00148 $0.00
11005 00160 $0.00
11006 00162 $0.00
11008 00164 $0.00
11010 0016T $0.00

I need to use Column B code as the reference and if there is a match with column A populate a Column D with the code and column E with the price.

1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
Jul 18, 2010 at 09:29 AM
Will it not be easy to have a match of B vs Col A and put the value in E.
Having said that, in you sample data, i dont see any match
0