Search sheet for name and return row value

BillH80

New Member
Joined
Oct 13, 2019
Messages
4
I am a novice formula writer and I am working on a spread sheet for a non-profit group. I am trying to search a name in a certain column on a master sheet and return the entire row to another sheet. The column on the master sheet contains more than one row with the name I want to search. Can you help?
 

My Aswer Is This

Well-known Member
Joined
Jul 5, 2014
Messages
16,066
I do not believe a formula can do this.
I believe you would need to use Vba

And any time you need help it's always necessary to provide specific details

1. You said search a column but did not say what column.
And we need both sheet names
 

BillH80

New Member
Joined
Oct 13, 2019
Messages
4
I do not believe a formula can do this.
I believe you would need to use Vba

And any time you need help it's always necessary to provide specific details

1. You said search a column but did not say what column.
And we need both sheet names
Sheet 1 is labeled Master and Column B contains town names. Sheet 2 is labeled Albion which is a town name. From sheet two I want to search column B of Master for Albion and when found return the entire row that contains Albion in it to Sheet two.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
30,317
Office Version
365
Platform
Windows
Hi & welcome to MrExcel.
How about in A2 filled down & across
=IFERROR(INDEX(Master!A$2:A$8822,AGGREGATE(15,6,(ROW(Master!A$2:A$8822)-ROW(Master!A$2)+1)/(Master!$B$2:$B$8822="Albion"),ROWS($A$2:$A2))),"")
 

BillH80

New Member
Joined
Oct 13, 2019
Messages
4
Thank you very much. It works exactly as I needed. Thanks Again!!!
 

BillH80

New Member
Joined
Oct 13, 2019
Messages
4
Sent this to the end user who is using Open Office and I was using Excel and the formulas error out in Open Office. Any suggestions for that program?
thanks,
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
30,317
Office Version
365
Platform
Windows
Thank you very much. It works exactly as I needed. Thanks Again!!!
You're welcome & thanks for the feedback.

Sent this to the end user who is using Open Office and I was using Excel and the formulas error out in Open Office. Any suggestions for that program?
thanks,
I've never used Open Office, so have no idea.
 

Forum statistics

Threads
1,077,993
Messages
5,337,602
Members
399,156
Latest member
RaudMees

Some videos you may like

This Week's Hot Topics

Top