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

0 votes

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?

Oct 29 in Others by Kithuzzz
• 20,660 points
43 views

1 answer to this question.

0 votes

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

enter image description here

answered Oct 29 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
1 answer

In a excel formula I need to create a list of names on one sheet based upon criteria/data of another sheet

The final formula is: =IF(ROWS($H$3:H3)<=$I$1,INDEX(Personnel! ...READ MORE

answered Nov 25 in Others by narikkadan
• 37,660 points
19 views
0 votes
1 answer
0 votes
0 answers

How can I sort arrays and data in PHP?

These are my primary questions: How do I ...READ MORE

Aug 8 in Others by krishna
• 2,820 points
61 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16 in Others by Edureka
• 13,640 points
142 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

answered Feb 16 in Others by Edureka
• 13,640 points
240 views
0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

Feb 17 in Others by Edureka
• 13,640 points
109 views
0 votes
1 answer

IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE

answered Feb 18 in Others by gaurav
• 22,040 points
71 views
0 votes
1 answer

How can I use a command button in excel to set the value of multiple cells in one click?

Try this: Private Scan As Integer Private Sub CommandButton1_Click() ...READ MORE

answered Oct 24 in Others by narikkadan
• 37,660 points
62 views
0 votes
1 answer

Excel - How can I get the average of cells where the value in one column is X and the value in another column is Y?

Use AVERAGEIFS ... =AVERAGEIFS(C2:C13,A2:A13,"Yellow Typ ...READ MORE

answered Nov 11 in Others by narikkadan
• 37,660 points
36 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP