I'm looking to compare values in 2 columns in two
different work sheets... If for example; If the ID in
sheet 1 A1:A10 is equal to ID in sheet 2 D1:D10, then
copy the adjacent 3 cells to Sheet 1...

Sheet 1

A B C D E F G
12
13
14

Sheet 2

D E F G
11 1 2 3
13 4 5 6
16 7 8 9
14 3 2 1

Result after Function;

Sheet 1

A B C D E F G
12
13 4 5 6
14 3 2 1

Any help would be greatly appreciated;
Thanks
Kevin