help with pulling data from other worksheets

I need some help:

sheet 1 has cells a1, b1, c1, d1
a2, b2, c2, d2
etc.
sheet 2 has cells e1, f1, g1, h1
e2, f2, g2, h2
etc.

on sheet 2 i want e1=a1, f1=b1, c1=g1 if d1 is = xxxxx
e2=a2, f2=b2, c2=g2 if d2 is = xxxxx

on sheet 2 i want e1=a1, f1=b1, c1=g1 if d1 is = xxxxx
e2=a2, f2=b2, c2=g2 if d2 is = xxxxx

aren't these reversed? g1=c1 would be consistent, particularly as there is no g1 on Sheet 1



On Sheet 2 in E1 enter
=IF($D1="xxxxx",Sheet1!A1,"") then copy across and down

this puts the data you want in the cell and leaves it blank if xxxxx is not found

this is not case sensitive