Match Full spreadsheets

[blossomthe2nd]

Hi guys,
We are switching systems in work and I have loads of customer numbers that will now be assigned new numbers.
I wish to call off to ensure all the data is transfered correctly and am wondering the quickest way to do this....

I have 1 spreadsheets with Old Customer Numbers in Column A and 86 different columns with data such as Address , phone etc , columns C : CE

the other spreadsheet has New Customer Numbers in Column A and 86 different columns with data such as Address , phone etc , columns C : CE

I have completed a V lookup and added another column in B so I know which new relates to which old.

The sheets "should" be formatted the same way

I had planned on vlookuping results from one sheet to another then doing a match on the result , but I would have to write this 86 times , or I had thought on concatenating all 86 field and try and match that but it only takes 30 text fields.

So I guess my query is ,

Is there a way to MATCH the data on 2 spreadsheets quickly and efficently

Thanks so much

A