google sheets
I'm working on a document that I would like to have a sheet that searches another sheet for a specific value that I type in (a name) and return content from all of the rows that have that value in their first column. Similar to vlookup, but include not just the content from the first row found.
In my document, the desired formulas will be on "lookup" and "example" is an example of how I would like it to function.
Why not have a column that concatenates ACC and UNQ#, like:-
AAA-1000
AAA-1002
Then when AAA was typed in you would get the two options, then you can use SPLIT to get the UNQ# to do the second vlookup.
This can be done in a couple of ways, depending on how the spreadsheet will evolve later.
After this, only the rows with Centre A will be shown. You can copy-paste into the new sheet; only visible cells will be copied.
Reference: filtering your data.
FILTER command: for example, =FILTER('Master Sheet'!A:D, 'Master Sheet'!D:D="Centre A")
With this approach, any future edits to the master will propagate to Centre A sheet. You will not be able to edit this data in Centre A sheet.
Best Answer
filterworks, but withqueryyou can get all needed columns with one command:The messy end of query string is arranged so that if B1 contains Student Name, the query becomes
"select B, D, E where A = 'Student Name'"