如何从excel中的sheet1获取sheet2中的数据 [英] how to get data in sheet2 from sheet1 in excel

问题描述

我有两个工作表，

Sheet1
Column A = Deptname
Column B = Headname
Column C = Username

Sheet2
Column A = Headname (???)
Column B = Username
Column C = UserID

头名列是空白的，想要做的是通过使用用户名从Sheet1获取头名。

"Headname" column in Sheet2 is blank and what I wanted to do is to get "Headname" from Sheet1 by using "Username".

我试图使用 VLookup ，但是如果Sheet1和Sheet2中的用户名不完全相同，则不起作用。

I have tried to use VLookup but it did not work if username in Sheet1 and Sheet2 is not exactly same.

EG，给出两个不同的用户名，如下所示。

E.G, given two differents Username as shown on below.

• 用户名< Sheet1中的$​​ c $ c> Jenny Oh和Chan Shu Mei
$ b Sheet2中的$ b
• 用户名ITC - Jenny Ong和IA ：陈树梅

• Username in Sheet1 is "Jenny Oh" and "Chan Shu Mei"
• Username in Sheet2 is "ITC - Jenny Ong" and "IA: Chan Shu Mei"

任何想法是否可以完成？谢谢提前获得任何帮助。

Any ideas whether it can be done? Thankf in advance for any help.

推荐答案

您可以访问另一个工作表中的单元格： = sheet1 ！B53;

You can access cells in another sheet like this: =sheet1!B53;

这篇关于如何从excel中的sheet1获取sheet2中的数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！