Define Name: Reference name range from another workbook

[inddon]

Hello There,

I have 2 workbooks, master and detail.

In the detail, I created a define named range giving reference to the master workbook.
Also, in the detail workbook, I created a Vlookup referencing the cell value to the above named range of master workbook.

I am getting an error. I have attached the sample workbooks for your reference.

Could you please help how the reference could work?

Thanks & regards,
Don

 

[Luke M]

You've got the RangeMasterOne range defined as a SUM, rather than just the range of cells. In Details workbook, RangeMasterOne should be defined as:
=Master.xlsx!Table1[[Words]:[Description]]

and then the VLOOKUP will work.

 

[inddon]

Thank you Luke. It works.