Getting range names from external workbook

[ahisklai]

Hi. Is it possible to use names from external workbook? I couldn't manage to find a way to connect workbooks so I could use external names.

This is my external workbook:

From my local workbook I want to look up a range name with VLOOKUP, and then look up needed percentage based on the range name.

 

[BiocideJ]

You should be able to reference it simply using
[workbookname]!namedrange

for instance [My Open Workbook.xlsx]!MyNamedRange

 

[ahisklai]

You should be able to reference it simply using
[workbookname]!namedrange

for instance [My Open Workbook.xlsx]!MyNamedRange

Wow, that easy, huh.
Thanks!