excel中vlookup_从另一个工作簿中的Excel VLOOKUP

最新推荐文章于 2023-07-13 14:38:01 发布

culiao2169

最新推荐文章于 2023-07-13 14:38:01 发布

阅读量2.7k

点赞数

文章标签： python java excel linux git

原文链接：https://contexturesblog.com/archives/2010/08/23/excel-vlookup-from-another-workbook/

版权

excel中vlookup

If you're filling in an order form in Excel, you can use the VLOOKUP function to find the selling price for each item in the sales order. For example, in the screen shot below, the order form is on the Orders worksheet, and a VLOOKUP formula in column D pulls the cost from a pricing table on the Prices worksheet.

如果要在Excel中填写订单表格，则可以使用VLOOKUP函数查找销售订单中每个项目的售价。例如，在下面的屏幕快照中，订单窗体位于“订单”工作表上，并且D列中的VLOOKUP公式从“价格”工作表上的定价表中提取成本。

在另一个工作簿中查找范围 (Lookup Range in Another Workbook)

However, you might want to keep your price list separate from the orders workbook, so the prices are easy to update. If your price list is in a different workbook, you can still use a VLOOKUP formula to pull the data, by referring to the external list.

但是，您可能希望将价目表与订单工作簿分开，因此价格很容易更新。如果您的价目表在其他工作簿中，则仍然可以使用VLOOKUP公式通过引用外部清单来提取数据。

To refer to another workbook in a VLOOKUP formula, follow these steps.

要在VLOOKUP公式中引用另一个工作簿，请按照下列步骤操作。

Open both workbooks (this step isn't mandatory, but makes it easier to create the link)
打开两个工作簿(此步骤不是强制性的，但使创建链接更容易)
Create the VLOOKUP formula, and for the table_array argument, select the lookup range in the other workbook. Excel will automatically add the other workbook's name and the worksheet name in the formula.
创建VLOOKUP公式，并为table_array参数选择另一个工作簿中的查找范围。 Excel将自动在公式中添加其他工作簿的名称和工作表名称。

In the screen shot below, the lookup table is in the PriceList.xlsx workbook, on the Prices sheet, in a range named PriceLU.

在下面的屏幕快照中，查找表在PriceList的PriceList.xlsx工作簿中，位于PriceLU的范围内。

关闭查找工作簿 (Closing the Lookup Workbook)

While the price list lookup table workbook is open, the VLOOKUP formula will show the workbook name and the referenced range address or range name.

价格表查找表工作簿处于打开状态时，VLOOKUP公式将显示工作簿名称以及引用的范围地址或范围名称。

You can see the PriceLU name and workbook information in the formula bar, in the screen shot below.

您可以在下面的屏幕快照的编辑栏中看到PriceLU名称和工作簿信息。

If the price list lookup table workbook is closed, the VLOOKUP formula will still work, and the full file path for the price list lookup table workbook will be shown in the formula.

如果关闭了价目表查找表工作簿，则VLOOKUP公式仍将起作用，并且价目表查找表工作簿的完整文件路径将显示在公式中。