G
Guest
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 D110, 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
different work sheets... If for example; If the ID in
sheet 1 A1:A10 is equal to ID in sheet 2 D110, 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