How can I sort one set of data to match another set of data in Excel

Question

I have a list of information that is neither numbered nor in alphabetical order. A second list with the same date needs to be sorted in the same way as the first list. I am unable to alter the data's order. My objective is to copy more data from the second set and paste it into the first data set.

**DATA SET A**           **DATA SET B**
22350   ____              BH160   100
22355   ____              22350   125
BH160   ____              BH190   200 
BH190   ____              22355   150

I want a new column in DATA SET A to contain the numerical value from column 2 of DATA SET B. For instance, I want 125 to appear in DATA SET 1's line 1, column 2. My list contains about 200 unique numbers and I need to update it every week.

Can someone help me? Maybe with a macro that I could use each week?

Answer 1

In addition, INDEX MATCH is a more "potent" option than vlookup. You would get exactly what you want from this: