如何排序一组数据以匹配Excel中的另一组数据？ [英] How can I sort one set of data to match another set of data in Excel?

问题描述

我有一个不是字母或数字顺序的数据列表。我想排序同一日期的第二个列表来匹配第一个列表。我无法更改数据的顺序。我的目标是将第二组中的附加数据粘贴到第一个数据集中。

  **数据集A ** * *数据集B ** 
 22350 ____ BH160 100 
 22355 ____ 22350 125 
 BH160 ____ BH190 200 
 BH190 ____ 22355 150 
  / pre> 
 
 
我想从DATA SET B的列2中获取数值，显示在DATA SET A的新列中。例如，我想要125显示在DATA SET 1的第1列第2列。
 
 
 
我的列表包含约200个唯一号码，我需要每周更新一次。
 
 
 
有人能帮我吗？也许每周可以使用一个宏？
解决方案
您还可以使用 INDEX MATCH ，比vlookup更强大。这将给你你正在寻找的东西：
 
 
 
  
 
I have a list of data that is not in alphabetical or numerical order.  I want to sort a second list of the same date to match the first list.  I cannot change the order of the data.  My goal is to paste additional data from the second set back into the first data set.
**DATA SET A**           **DATA SET B**
22350   ____              BH160   100
22355   ____              22350   125
BH160   ____              BH190   200 
BH190   ____              22355   150
I would like to get the numerical value from column 2 of DATA SET B to show up in a new column of DATA SET A.  For example, I want 125 to show up in line 1, column 2 of DATA SET 1.

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?
解决方案
You could also use INDEX MATCH, which is more "powerful" than vlookup. This would give you exactly what you are looking for:



                        
这篇关于如何排序一组数据以匹配Excel中的另一组数据？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！