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?
 

Some videos you may like

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

My Aswer Is This

Well-known Member
Joined
Jul 5, 2014
Messages
16,729
Office Version
2013
Platform
Windows
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
36,145
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
36,145
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,090,459
Messages
5,414,643
Members
403,540
Latest member
mmorejon1215

This Week's Hot Topics

Top