[Solved] Assistance with Vlookup to match old accounts to new accounts

Hi all,

I am doing an internship and have been given a task involving macros to which I could use some help. I apologize if I confuse you with my description.

We are currently switching accounting systems and I am interested in a macro that takes the old account number and in a separate column gives me the new account number.

There is a workbook that lists the old account numbers and their corresponding new account numbers. In a separate workbook I have 88 worksheets for various different projects that need the accounts to be matched with the new account numbers.

Essentially, I need a macro that say if I have "xxxx" in A# then I# = "xxxx". If A# is empty then I# is empty.

Here is an example:
Book1.xlsx

Thanks in advance for your help,
Mike