Excel has the =filter function which allows you to filter a range or an array. You can use it to return multiple rows based on a value or values.
For example, from your current sheet you could return all rows from a connected sheet where "FY2020" is found in column A.
Will the =filter be added to Wdesk Spreadsheets? I don't see it there now.
Is there another way in Spreadsheets to return multiple rows based on a value as described above?