title: Refer to named range in another excel workbook
body: <p>D.xls is a reference worksheet used to define commonly used infomation for a bunch of other worksheets.</p>
  
  <p>D.xls has named ranges for this and that. One of them is Containers</p>
  
  <p>In I.xls I want to use a VLOOKUP on one of D's named ranges.</p>
  
  <p>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.</p>
  
  <p>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.</p>
  
  <p>Possible?</p>
  
  <p>Additions:</p>
  
  <p>The actual formula is:</p>
  
  <p>=IF(ISBLANK($E2),,VLOOKUP($E2,[D.xlsx]ABS!$E$2:$J$300,5,0))</p>
  
  <p>This works.</p>
  
  <p>Over in D I define Trees to be a named range E2:J300</p>
  
  <p>So, If I am reading your answer correctly, I should be able to change the above to</p>
  
  <p>=IF(ISBLANK($E2),,VLOOKUP($E2,[D.xlsx]!Trees,5,0))</p>
  
  <p>I get the 'Your formula has an error and the sheet reference is highlighted in the formula bar.</p>