I’m trying to make a spreadsheet where you input 4 parameters, and it returns an new array from a larger array only containing rows where all 4 parameters were met.

I’m trying to use some of the indexing commands, but it seems to return a value and not a spilled row.

As a last resort I could just make a macro that sorts the table and trims out the excess after doing 4 different sorts.

Using the index and match functions just to see if I could get it to work. I’ve searched around and can’t find anything that does this particularily in Excel. In an actual language it would be easy to just append an array, but allas. I tried using the filter command but it doesn’t appear to be able to filter based on an if statement.