I ahve a spreadsheet similar to this

Vendor ID Account Number Vendor IDa Account Numbera
10751 10460
56650-ME
10631 10923
56630-VT


The first vendor Id column has about 4,000 entries. The second vendor ID
column has about 15,000 entries and contains the 4,000 entries from the
first column in no particular order. I need to compare each number in
column "vendor ID" to all the numbers in column "vendor ida" and if there is
a match then the number in "account numbera" should be placed in the column
"account number" next to the correct vendor ID.

When this is all done, I need to have the 4,000 entries in "vendor ID' to
have the correct "account number" inserted next to them. Any help would be
appreciated! Thanks
Darren