Copy data from Sheet1 based on data in Sheet2 cell

[jue92]

Quite a simply resolution for someone, just not for me.

I have a data list in Sheet1.

Example:

Sheet1
A - B
Dave - EMAIL1
John - EMAIL2
Chris - EMAIL3

Sheet2
A - B - C
Dave - BLANK - AUTO FILLS EMAIL

I then have a working Sheet2. I want the formula to read the data in Sheet2, C:C, match it with Sheet1, A, then read Col2 and paste into Sheet2, E:E

Hopefully this makes sense?

[DJunqueira]

From your information.

Please Login or Register  to view this content.

File attached.