Help with creating VLOOKUP formula

[YellowTangerine]

Hello,

Would anyone please be able to help me construct the correct formula to create the desired results in the table below? I've not used VLOOKUP before so am a novice at this. Any support would be most gratefully received.
Thank you.

POC Data 050323.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	Child Name	Unique Code			Child Name	Unique Code	Parent Name	Parent Email			Parent Name	Parent Emai	Child Name	Unique ID
2	Child 3	359fh4			#N/A						Name 1	test1@gmail.com	Child 1	Not known requires a match from data source 1
3	Child 1	359fh5			#N/A						Name 2	test2@gmail.com	Child 2	Not known requires a match from data source 1
4	Child 5	359fh6			#N/A						Name 3	test3@gmail.com	Child 3	Not known requires a match from data source 1
5	Child 4	359fh7			#N/A						Name 4	test4@gmail.com	Child 4	Not known requires a match from data source 1
6	Child 2	359fh8			#N/A						Name 5	test5@gmail.com	Child 5	Not known requires a match from data source 1
7	Child 6	359fh9			#N/A						Name 6	test6@gmail.com	Child 6	Not known requires a match from data source 1
8
9	Data Source 1				Result						Data Source 2
Sheet1

Cell Formulas
Range	Formula
E2:E7	E2	=VLOOKUP($A2:$A7,$K$2:$N$7,COLUMN(A1),0)
Dynamic array formulas.

 

[Peter_SSs]

It is not clear to me what result(s) you expect for that sample data.

Can you fill in the desired results manually and post XL2BB again and explain again in relation to those expected results?

 

[YellowTangerine]

It is not clear to me what result(s) you expect for that sample data.

Can you fill in the desired results manually and post XL2BB again and explain again in relation to those expected results?

Yes, of course. See below. Source 1 is presented in my example in a different order to source 2, however i have yet to see the data source 1 (for real) and this may be received in the same order as data source 2. The main thing I am trying to achieve is to ensure the correct Unique ID is applied to the correct child and parent name. Child 1 is to be matched to Name 1 etc... along with the unique ID. This information will be used in a mailmerge and the Unique ID gives them access to setting up their account on a system. Hope this helps.

POC Data 050323.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	Child Name	Unique Code			Child Name	Unique Code	Parent Name	Parent Email			Parent Name	Parent Emai	Child Name	Unique ID
2	Child 3	359fh4			Child 1	359fh5	Name 1	test1@gmail.com			Name 1	test1@gmail.com	Child 1	Not known requires a match from data source 1
3	Child 1	359fh5			Child 2	359fh8	Name 2	test2@gmail.com			Name 2	test2@gmail.com	Child 2	Not known requires a match from data source 1
4	Child 5	359fh6			Child 3	359fh4	Name 3	test3@gmail.com			Name 3	test3@gmail.com	Child 3	Not known requires a match from data source 1
5	Child 4	359fh7			Child 4	359fh7	Name 4	test4@gmail.com			Name 4	test4@gmail.com	Child 4	Not known requires a match from data source 1
6	Child 2	359fh8			Child 5	359fh6	Name 5	test5@gmail.com			Name 5	test5@gmail.com	Child 5	Not known requires a match from data source 1
7	Child 6	359fh9			Child 6	359fh9	Name 6	test6@gmail.com			Name 6	test6@gmail.com	Child 6	Not known requires a match from data source 1
8
9	Data Source 1				Result						Data Source 2
Sheet1

 

[YellowTangerine]

It is not clear to me what result(s) you expect for that sample data.

Can you fill in the desired results manually and post XL2BB again and explain again in relation to those expected results?

Unique ID & Unique Code are both the same. Sorry, I should have used just the one term.

 

[Fluff]

Duplicate to: VLOOKUP and match return in whole column

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.