VLOOKUP and match return in whole column

[YellowTangerine]

Hello, I'm new here. Apologies ahead of I don't use the correct terminology.

I have data coming from two sources that I need to combine and match on a spreadsheet. The answers can't be returned in a single cell but match through and answered for each row in a column.

One source supplies just a name in one column and a unique code for each name in a second column.

The second source supplies the name (which matches the first source) but also an email address and another name associated with the name in the first source.

I need to bring all three pieces of information together into one worksheet and wondered if there is a way to use the VLOOKUP to populate cell in a column with a match, rather than just returning an answer in one cell.

Thank you in advance for your support.

 

[Legacy 143009]

Can you provide some sample source, sample destination and some desired result?

 

[YellowTangerine]

Here's an example of raw data from one system in the left. On the right is the desire outcome. Source data from second source includes name, address, email etc but not included. I'm am a basic spreadsheet user. Hope this helps. Thank you in advance.

 

[YellowTangerine]

Here's an example of raw data from one system in the left. On the right is the desire outcome. Source data from second source includes name, address, email etc but not included. I'm am a basic spreadsheet user. Hope this helps. Thank you in advance.

I forgot to say, I must have the unique ID remain with the first name. I will be doing a mailmerge and the unique ID will go into the body of the letter. It's used to set up an account for Name 1.

 

[Legacy 143009]

This is a simple VLOOKUP issue. I don't get what you mean by "match the whole column". You can automate it with getting index from column:

=VLOOKUP($A2,$H$2:$J$5,COLUMN(A1),0)

 

[YellowTangerine]

This is a simple VLOOKUP issue. I don't get what you mean by "match the whole column". You can automate it with getting index from column:

=VLOOKUP($A2,$H$2:$J$5,COLUMN(A1),0)

View attachment 86786

Thank you. I'll go and see if I can replicate this. Sorry about my poor terminology. I need to match all the data so that each Name 1 column is correctly matched to the correct email address in the second source data. Hope that makes better sense?

 

[YellowTangerine]

Thank you. I'll go and see if I can replicate this. Sorry about my poor terminology. I need to match all the data so that each Name 1 column is correctly matched to the correct email address in the second source data. Hope that makes better sense?

What does getting from index column mean?

 

[Legacy 143009]

Unfortunately I don't get it. Maybe you should wait for other replies.

 

[YellowTangerine]

Thank you. I'll go and see if I can replicate this. Sorry about my poor terminology. I need to match all the data so that each Name 1 column is correctly matched to the correct email address in the second source data. Hope that makes better sense?

I now understand. Thank you. How can I ensure the Unique ID is included in the result of the VLOOKUP please?

 

[YellowTangerine]

This is a simple VLOOKUP issue. I don't get what you mean by "match the whole column". You can automate it with getting index from column:

=VLOOKUP($A2,$H$2:$J$5,COLUMN(A1),0)

View attachment 86786

Thank you so much. I am uploading a sample data spreadsheet which should make it much clearer. This is a new area for me. I'm so grateful for your support. I hope you will be able to see the outcome I now desire and my apologies for the poor communication from my side. Please see below:

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

Cell Formulas
Range	Formula
E2:E7,G2:G7	E2	=VLOOKUP($A2:$A7,$K$2:$M$7,COLUMN(A1),0)
F2:F7	F2	=VLOOKUP($B2:$B7,COLUMN(B1),0)
Dynamic array formulas.