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?
 

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.
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
 
Upvote 0
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.
 
Upvote 0
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))),"")
 
Upvote 0
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,
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,213,520
Messages
6,114,101
Members
448,548
Latest member
harryls

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top