I have a list of about 18000 records comparing accounts from two databases. At one point people thought it would be a good idea to have different account numbers...
My list looks like this:
Accounts1.PNG
I can match the First account number And at least the first 7 characters of the address.

I would like it to look like this in the end not sure if it can be done in one sheet or if it has to be populated into it's own sheet:
accounts2.PNG

Any thoughts or direction someone can point me in??

Thanks,