Mapping XL Doc 1 to Doc 2

Hi,

I have two columns Col A and Col B in one xl document. Both Col A and Col B contains numbers under each cell and they are mapped to each other (Col A is mapped to Col B). I have same Col A in second document (Col A in document 1 and 2 are the same) and need to map doc 2 Col A with doc 1 Col B. I want to map cell to cell so that doc 1 Col A and Col B should exactly map with doc 2 Col A and Col B. Doc 2 Col A contains multiple entries so getting difficulties while mapping the docs.

Attached the Doc 1 and Doc 2.

So please send me if any Macros for the above.

Copy doesn’t work since Doc 2 Col A number order is different from Doc 1 Col A order and Doc 2 Col A contains multiple entries.

Thanks in advance...