从不同的工作簿Vlookup到主工作簿 [英] Vlookup into master workbook from different workbooks

问题描述

有一个主工作簿，其中包含与5个处理不同帐户(公司)的人员有关的广泛信息.这5个人按姓名过滤并更新其相关帐户的信息，并将他们的主工作簿副本发送回给我.它们突出显示了完成更新的帐户名称.

There is master workbook containing extensive information pertaining to 5 people who handle different accounts (companies). These 5 people filter by their name and update information of their related accounts and send back their copy of master workbook to me. They highlight the account names where the updates have been done.

我必须将它们的更新合并到我维护的主工作簿中.我目前正在手动进行操作，方法是在主工作簿中过滤它们的名称，并将突出显示的颜色帐户的更新复制到主"中.

I have to incorporate their updates in the master workbook that i maintain. I am currently doing manually by filtering their name in master workbook and copying updates of the highlighted color accounts to the Master.

我可以在这里进行vlookup吗?什么是更有效的方法?我是vlookup的学习者，只知道如何从一张纸到另一张纸，而不是从多张到单张工作簿.

Can i do a vlookup here? what is a more effective way? I am learner with vlookup and only know how to do it from one sheet to another not from Multiple to single workbook.

请帮助

推荐答案

您可以在多个工作簿上使用vlookup.

You can use vlookup on multiple workbooks.

=VLOOKUP(D1,[Book2]Sheet1!$C$1:$F$22,1,FALSE)

在上面的示例中，在Book2.xls的sheet1中的表$ C $ 1:$ F $ 22中查找D1的值.对于您的情况:键入公式时，只需指向主工作簿中的表即可.Excel会自动执行.

In the sample above, lookup the value on D1, in the table $C$1:$F$22 in sheet1 in Book2.xls. In your case: just point to the table in the master workbook while you typing the formula. Excel will do it automatically.

这篇关于从不同的工作簿Vlookup到主工作簿的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！