请参阅另一本Excel工作簿中的命名范围 [英] Refer to named range in another excel workbook

问题描述

D.xls是一个参考工作表，用于为一堆其他工作表定义常用的信息.

D.xls is a reference worksheet used to define commonly used infomation for a bunch of other worksheets.

D.xls已经为此命名了范围.其中之一是容器

D.xls has named ranges for this and that. One of them is Containers

在I.xls中，我想在D的命名范围之一上使用VLOOKUP.

In I.xls I want to use a VLOOKUP on one of D's named ranges.

我可以在公式中引用D的命名范围吗?如果是这样，语法是什么?名称不与工作表相关联，因此[Workbook] SheetName！explict_range语法不起作用.

Can I refer to D's named ranges in a formula? If so, what is the syntax? Names aren't associated with a sheet so the [Workbook]SheetName!explict_range syntax doesn't work.

在寻求帮助时，我可以将其定义为目标工作簿中的命名范围，但是他将需要在每个使用D的工作簿中重新定义它.我宁愿在D中定义它，并在需要的地方使用它.

Searching for help, I can define it as a named range in the destination workbook, but his will require redefining it in every workbook that uses D. I'd rather define it in D and use it where I wish.

可能吗?

添加项:

实际公式是:

= IF(ISBLANK($ E2),, VLOOKUP($ E2，[D.xlsx] ABS！$ E $ 2:$ J $ 300,5,0))

=IF(ISBLANK($E2),,VLOOKUP($E2,[D.xlsx]ABS!$E$2:$J$300,5,0))

这有效.

在D中，我将树定义为命名范围E2:J300

Over in D I define Trees to be a named range E2:J300

因此，如果我正确阅读了您的答案，则应该可以将以上内容更改为

So, If I am reading your answer correctly, I should be able to change the above to

= IF(ISBLANK($ E2),, VLOOKUP($ E2，[D.xlsx]！Trees，5,0))

=IF(ISBLANK($E2),,VLOOKUP($E2,[D.xlsx]!Trees,5,0))

我得到您的公式有误，并且表格引用在公式栏中突出显示.

I get the 'Your formula has an error and the sheet reference is highlighted in the formula bar.

推荐答案

您只需使用:=[workbookName]!namedRange

例如:=D!salesData

这篇关于请参阅另一本Excel工作簿中的命名范围的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！