Hi,

Assuming data is in A3:A5 in sheet 1 and in A3:A5 of sheet 2 (Names1). In
B1 of sheet 1, enter the following array formula (Ctrl+Shift+Enter)

=OR(EXACT(A3,Names1!$A$3:A5))

The repeated ones will be called TRUE else FALSE

Regards

"Jessica" wrote:

> I have 2 worksheets, one of them contains a large number of accounts and then
> the second one has new figures that I can add to the first worksheet.
> Sometimes the second sheet will have new accounts on them but it is mixed in
> with the other 4,000 so its very difficult to find the new accounts. Right
> now I’m copying and pasting the account numbers and comparing them to the
> ones on the first sheet. Is there anything I can do to make searching for new
> accounts easier? Possibly using a VLOOKUP function to compare the account
> numbers to the ones on the master sheet to find new accounts?