I have looked through the questions but somehow I just can't find what I am looking for.
What am I looking for?
I have a document with 2 sheets. Let's say, sheet 1 is the backlog, sheet 2 is the sprint. In the spreadsheet, I have a selection (with dropdown) where I can pick the sprint I want to see. When I click on a certain sprint I want all the rows in the backlog where this sprint is selected in my sprint sheet.
The format of the columns is exactly the same, so I just need to display the WHOLE row when the match is met.
I tried with Vlookup but as far as I found it is just for one cell.
If anyone could help I would be glad!