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,077
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,525
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,525
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,078,444
Messages
5,340,317
Members
399,367
Latest member
ahmed elsaid

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top