How to copy a range of data if two cells match

[rockychelsea]

In Sheet 1, column C i have a list of employee codes

One Sheet 2, column A i have a list of employee codes

I would like to copy data from Sheet 2, columns B,C,D,E & F to Sheet 1 columns K,L,M,N & O only if employee codes match in column in Sheet 1, column C and Sheet 2 column A

If no match is found, there is no data that needs to be copied from sheet 2 to sheet 1

Help is greatly appreciate

 

[RobP]

Hi, welcome to the forum.

Perhaps a simple formula like this would help you :

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1			Code								datacopy
2			1234								blah1	clah2	dlah3	elah4	flah5
3			1235								blah1	clah2	dlah3	elah4	flah5
4			1236								blah1	clah2	dlah3	elah4	flah5
5			1237								blah1	clah2	dlah3	elah4	flah5
6			1238								blah1	clah2	dlah3	elah4	flah5
7			1239								blah1	clah2	dlah3	elah4	flah5
8			1240								blah1	clah2	dlah3	elah4	flah5
9			1355
10			1241								blah1	clah2	dlah3	elah4	flah5
11
12
13
14
15
16
17	Assuming Data in Sheet2 looks like this :
18	Code	data1	data2	data3	data4	data5
19	1234	blah1	clah2	dlah3	elah4	flah5
20	1235	blah1	clah2	dlah3	elah4	flah5
21	1236	blah1	clah2	dlah3	elah4	flah5
22	1237	blah1	clah2	dlah3	elah4	flah5
23	1238	blah1	clah2	dlah3	elah4	flah5
24	1239	blah1	clah2	dlah3	elah4	flah5
25	1240	blah1	clah2	dlah3	elah4	flah5
26	1354	blah1	clah2	dlah3	elah4	flah5
27	1241	blah1	clah2	dlah3	elah4	flah5
28
Sheet1

Cell Formulas
Range	Formula
K10:O10,K9,K2:O8	K2	=XLOOKUP(C2,Sheet2!A2:A50,Sheet2!B2:F50,"")
Dynamic array formulas.

 

[rockychelsea]

Thank you I will give it a go.