Build a consolidation list from array

Hi all,

Here I have another question. How to pull values from an array to the consolidation list excluding blanks. Bear in mmind there are two criteria - product and date.

See the attached dummy.

Thanks.

I'm sure you know how to correct for the error results so I have left that for you.

Try this (you can hide the helper column (A) on Data sheet).

try it this way