Need to match cols then move data to new col.

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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