Comparing two columns

[Arkimedes78]

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.

 

[ww4612]

can you put your data in an html sheet? i cannot read it.

 

[Arkimedes78]

Yes. I see that now. I will fix it right away. Thanks for quick reply

 

[Arkimedes78]

Im new here to this forum. How can I upload the file to this post?