Comparing two columns

Arkimedes78

New Member
Joined
Mar 18, 2016
Messages
3
I would like to compare two columns with numbers. If there is a match I will retrieve a number from a third column and put into a forth. Se below:

PN1 Price PN2 Match
18-510-580 23 112 200005282
3794456 5 099 7201659
200005281 230 480 P33225
DP-18-6056 1 133 18-510-580
7201659 19 956 3325000
18-910-200 32 158 P1000885
3794457 77 963 3794456
200005282 12 358 1235

If a number in PN2 is found in PN1, then the Price belonging to PN1 should be put in Match. I.E:

PN1 Price PN2 Match
18-510-580 23 112 200005282 12 358
3794456 5 099 7201659 19 956
200005281 230 480 P33225
DP-18-6056 1 133 18-510-580 23 112
7201659 19 956 3325000
18-910-200 32 158 P1000885
3794457 77 963 3794456 5 099
200005282 12 358 1235


Hope you can help.
 

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,151,825
Messages
5,766,659
Members
425,367
Latest member
Boboka

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top