Comparing arrays

Hi is it possible to compare two arrays and note if values are in the same array. I have two tables on the attached and have put both in separate arrays (see below).

In a similar way to the VLookup function could I compare each array and note in column F if the account number in column A is in the second table column H.

Please Login or Register  to view this content.

Please Login or Register  to view this content.