Compare cells from different workbooks and copy other cell if match

[Thoeng]

Hi,

New to the forum and looking for a solution to a problem i'm having at work.

I've got 2 different workbooks that i would like to compare.
If the data from two cells match, i want to copy a cell to the other workbook.

So:

If Cell A Workbook 1 matches Cell A Workbook 2 ==> Copy Cell B Workbook 2 to Cell B Workbook 1

Thanks!

 

[Thoeng]

Any help would be greatly appreciated!

Thank you

 

[Sektor]

This can be achieved by different ways in VBA. It'd be easier if you'd put your file to cloud so that it could be reviewed more in detail (the real structure).

 

[Thoeng]

Thank you Sektor!

I've put the file on my dropbox:
https://www.dropbox.com/s/vezgqmupfoc3cfb/Masterfile.xlsx?dl=0

What i want to do is the following:
If the text in column P of sheet 1 matches the text in column D of sheet 2,
I want to copy the emailadres in column M of sheet 1 to column E of sheet 2.

Thank you in advance for any help!

 

[Thoeng]

Any ideas?

 

[Thoeng]

Any ideas?

Problem has been resolved.
Thank you