My spreadsheet is located here, everyone should have edit permissions: https://docs.google.com/spreadsheets/d/1TGwDf5vTsHbDGiNZBTRHDwVpHZd9lzx2r1abV0ygPBE/edit?usp=sharing

I’m trying to figure out how to stack multiple FILTER() functions in the tab “Oct 19 – Morning” when the range being filtered by each function is an array. I’m trying the following function in the code block, but it’s returning an error that says “In ARRAY_LITERAL, an Array Literal was missing values for one or more rows.“

={ FILTER( {‘Master Sheet’!$C$2:$D,’Master Sheet’!$E$2:$E},SEARCH(““,’Master Sheet’!$E$2:$E)) ; FILTER( {‘Manual
Addition’!$A$2:$A,’Manual Addition’!$C$2:$C}, SEARCH(““,’Manual
Addition’!$C$2:$C)) }

The filters work fine by themselves, but when stacked together they’re producing the error.