Dlookup在表中 [英] Dlookup in Table

问题描述

我正在尝试创建一个自动从另一个表进行查找的列。完全像Excel中的VLookup公式。我在网上看到的只是通过向导查找值，但只提供下拉列表。 

I am trying to create a column that automatically does a lookup from another table. Exactly like a VLookup formula in Excel. All I am seeing for this online are lookupvalue through the Wizard, but that only gives a drop down list. 

非常感谢任何帮助。 

Any help is greatly appreciated. 

推荐答案

如果您正在考虑使用计算字段，我认为您不能在表级查找其他表。但是，您可以使用数据宏从其他表中查找值，以便在宏所在的表中使用。你究竟想要
来完成什么？

I don't think you can look up other tables at the table level, if you're thinking of using a calculated field. However, you can use data macros to look up values from other tables for use in your table where the macro resides. What exactly are you trying to accomplish?

这篇关于Dlookup在表中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！