I have a table with 500+ rows in Sheet 1 (let's call this "masterlist".
In another sheet, I'd like to be able use a drop-down cell containing certain key values (all taken from a single column in the masterlist), to subsequently populate a table with all the rows match that match.
Ironically I can do this effortlessly in MySQL but alas I need to produce a spreadsheet on this occasion and I am nub. For those savvy with SQL, a more succinct description of the problem is:
SELECT * FROM
id_column = 'target value'
Though, to be fair, since the size of selected output is unknown, I also don't understand how to populate the receiving table (in Numbers) with an unknown number of rows.