Copy data from one Excel sheet to another but on if data in to columns match

[solsearcher]

Hello,
I'm sure this a job for an Excel macro but I'm a newbie and have tried loads of methods to get this to work.
I have two sheets of data Sheet1 is the master with Columns A to O populated. Sheet2 has 5 Columns of data A to E, Column A of this sheet holds the same data as Column E in Sheet1.

I would like to add Columns B,C,D & E of sheet2 to columns P,Q,R & S of Sheet1 only if the Column A of sheet2 and column E of sheet1 match.

Could someone help?

 

[namliam]

Try using a VLookup formula to transport the data for you

 

[solsearcher]

THANKS I'll do some research.

 

[Brianwarnock]

Doesn't VLOOKUP work!
Assuming sheet2 has 500 rows

In sheet1 A1 = vlookup(e1,sheet2!A1:A500,2,False) and copy down

Etc

Brian

Oh I see Namliam posted while I was typing, I'm slow

 

[solsearcher]

Thanks a lot it works.....