Just as a heads up you could use Formulae for this:

AA10: =IF(ISNA(MATCH($Z10,$B:$B,0)),"",INDEX(D:D,MATCH($Z10,$B:$B,0)))
copy above across entire results table (ie AA10:AC71)

As you can see if implementing the above you will be calling the ISNA(MATCH test 3 times per row (Date, Customer HC, Shipping), it would of course make more sense to store the result of the MATCH in another column and reference that column in the other three cells so as to reduce number of calcs being performed... avoiding repetitive calcs is a good habit to get into.

As I say, just an alternative.