Compare Excel using OR/EXACT (Excel 2007 and above)

[surge79uwf]

Hi. I would like to know how to compare two lists to match. I have two lists, List A is of different account numbers (total is 1 million plus) and list B is of records of different documents according to account number, so one account number may have one document, several documents or none at all. I would like to have List B's account numbers validated according to List A's numbers, so if one number in List B is not included in List A it should say something like "false", "invalid" or the like. I have about 450,000 records in List B and, as I mentioned earlier, 1 million plus different records (account numbers) in List A. I tried (OR (EXACT(B1, $A$1:$A$1000003)) but nearly all the values come out FALSE, which is incorrect as some numbers in B are included in A.

 

[cb12]

I think given the quantity of data your best bet would be to use Access (or other database program) and run an update query.