Refer to named range in another excel workbook

Question

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

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

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

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.

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.

Possible?

Additions:

The actual formula is:

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

This works.

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))

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

Answer 1

You simply use: =[workbookName]!namedRange

For example: =D!salesData