Compare values in Array 1 and Array 2

Hello,

I need help with comparing the vaules in array1 with values in array2 and record the value from array 1 that does not match any value in array2.

Currently, my codes are like this.

Please Login or Register  to view this content.

As shown in the code, I have 3 arrays, ReportBN, ActualBN, and WrongBN. From there, I need to check EVERY ReportBN's value with ActualBN.
If ReportBN's value exist in any of ActualBN's value, then its okay. Else need to be recorded as WrongBN and printed on column D.
Is it possible to do so? Please help!

Thank you,
Daniel

One way

Please Login or Register  to view this content.