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

问题描述

我有一个不按字母或数字顺序排列的数据列表.我想对同一日期的第二个列表进行排序以匹配第一个列表.我无法更改数据的顺序.我的目标是将第二个数据集中的其他数据粘贴回第一个数据集中.

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

我想从 DATA SET B 的第 2 列中获取数值以显示在 DATA SET A 的新列中.例如，我希望 125 显示在 DATA SET 1 的第 1 行第 2 列中.

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.

我的列表包含大约 200 个唯一号码，我需要每周更新.

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?

推荐答案

你也可以使用 INDEX MATCH，它比 vlookup 更强大".这将为您提供您正在寻找的内容:

You could also use INDEX MATCH, which is more "powerful" than vlookup. This would give you exactly what you are looking for:

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