For my own simplicity, I'll refer to the worksheet in which you're entering this formula as This.
Breaking down your formula, you want all items in 'Stock In by Invoices'!J5:J for which cells in 'Stock In by Invoices'!E5:E match This!D5:D AND 'Stock In by Invoices'!F5:F match This!E5:E AND 'Stock In by Invoices'!I5:I match This!I5:I. I figure Google Sheets' MATCH function will only return ONE value when its 1st argument is a single value.
If you really are using Google Sheets, you should use its FILTER function for this.
Bookmarks