Is there a formula that will match a cell with another and if it matches, then bring the info from following cells to desired cell?

[trinitybg10]

I am not sure how to ask this exactly. I am trying to create a specific address book. I have an address book with a bunch of random people, but I want only family in the one that I am making. So I have my regular address spreadsheet and I have the names of whom are in the family in another spreadsheet. What I want is to match the name from the family spreadsheet to what is in the regular spreadsheet then move the address, phone number, and email from the row to the family spreadsheet. I hope this makes sense.
For example,
Regular sheet
John Jacob 123 Jingle St. Heimer, SM 12345 (555) 555 5555 1234email.123@email.com

Family sheet
John Jacob

And I want all the other information to be transferred.

Thank you for any help!

 

[dreid1011]

Welcome to Mr Excel. You can do this with either XLOOKUP or FILTER functions. If you post some sample data with your rows and columns on both sheets, someone can work something up for you.

 

[trinitybg10]

Welcome to Mr Excel. You can do this with either XLOOKUP or FILTER functions. If you post some sample data with your rows and columns on both sheets, someone can work something up for you.

Book1
	A	B	C	D	E
1	Ref Number	Name	Address	Phone number	E-mail
2	1	Garcia, Frank	1654 Arcineiga Dr. Portales, Georia 94673	579 698 5555
3	2	Harris, Alicia	7916 CRM J tenino washington	579- 316-8524
4	3	Langford, Carl	1212 MLK blvd Ft Campbell, KY	843-167-1895
5	4	Smith, Alex	4560 Grand St. quinten, WV	465-526-2316
Regular

Ok, I hope it comes up. It took me a minute to figure it out I actually haven't tried XLOOKUP, I did try IF, Index, and Match, as well as a combo of those, but I think I just got really confused. I am not sure how I would use Filter. I am trying to figure out a way that I don't have to go through each row if possible. Thank you for your help!!

 

[trinitybg10]

Book1
	A	B	C	D	E
1	Ref Number	Name	Address	Phone number	E-mail
2	1	Garcia, Frank	1654 Arcineiga Dr. Portales, Georia 94673	579 698 5555
3	2	Harris, Alicia	7916 CRM J tenino washington	579- 316-8524
4	3	Langford, Carl	1212 MLK blvd Ft Campbell, KY	843-167-1895
5	4	Smith, Alex	4560 Grand St. quinten, WV	465-526-2316
Regular

Ok, I hope it comes up. It took me a minute to figure it out I actually haven't tried XLOOKUP, I did try IF, Index, and Match, as well as a combo of those, but I think I just got really confused. I am not sure how I would use Filter. I am trying to figure out a way that I don't have to go through each row if possible. Thank you for your help!!

It didn't add the second sheet....
Either this link will show both, if not, the second one is the second sheet.

Book1
	A	B	C	D	E
1	Ref Number	Name	Address	Phone number	E-mail
2	1	Garcia, Frank	1654 Arcineiga Dr. Portales, Georia 94673	579 698 5555
3	2	Harris, Alicia	7916 CRM J tenino washington	579- 316-8524
4	3	Langford, Carl	1212 MLK blvd Ft Campbell, KY	843-167-1895
5	4	Smith, Alex	4560 Grand St. quinten, WV	465-526-2316
Regular

Second one

Book1
	A	B	C	D	E
1	Name	Address	Phone number	E-mail
2	Garcia, Frank
3	Langford, Carl
4
5
Family

 

[shaowu459]

hi, try this

工作簿1
	A	B	C	D	E
1	Name	Address	Phone number	E-mail
2	Garcia, Frank	1654 Arcineiga Dr. Portales, Georia 94673	579 698 5555	0
3	Langford, Carl	1212 MLK blvd Ft Campbell, KY	843-167-1895	0
4
family

Cell Formulas
Range	Formula
B2:D3	B2	=XLOOKUP(A2,Regular!B:B,Regular!C:E)
Dynamic array formulas.