根据标准(MS Excel)将一列复制到另一列 [英] Copy one column to another based on a Criteria (MS Excel)
本文介绍了根据标准(MS Excel)将一列复制到另一列的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有两张表Sheet1,Sheet2
Sheet1:
A | B
-----
123 |
456 |
789 |
表2:
A | B
-----
123 | DATA1
789 | DATA2
456 | DATA3
我希望Sheet1具有以下输出:
A | B
-----
123 | DATA1
456 | DATA3
789 | DATA2
我有一个非常基本的VB知识,可以帮助您以任何方式实现吗? >
谢谢。
解决方案
Sheet1,单元格B1: = VLOOKUP(A1,Sheet2!$ A $ 1:$ B $ 3,2,0)
并拖动应该给出所需的结果
编辑(VBA解决方案):
Sheet1.Range(B1:B3)。Formula == VLOOKUP(A1,Sheet2!$ A $ 1:$ B $ 3,2,0)
I've Two sheets, Sheet1, Sheet2
Sheet1:
A | B
-----
123 |
456 |
789 |
Sheet 2:
A | B
-----
123 | DATA1
789 | DATA2
456 | DATA3
I want The Sheet1 to have the following output:
A | B
-----
123 | DATA1
456 | DATA3
789 | DATA2
I have a very basic VB knowledge, Can you help accomplish this by any means?
Thanks.
解决方案
Sheet1, cell B1: =VLOOKUP(A1,Sheet2!$A$1:$B$3,2,0)
and drag down should give the desired result
Edit (VBA solution):
Sheet1.Range("B1:B3").Formula = "=VLOOKUP(A1,Sheet2!$A$1:$B$3,2,0)"
这篇关于根据标准(MS Excel)将一列复制到另一列的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文