Forum Discussion

Monti20's avatar
Monti20
Copper Contributor
Apr 10, 2020

VLOOKUP from other workbook

Dear tech community I'd like to get data with the VLOOKUP function from another workbook. It works well, if the other workbook is open, but doesn't if it's not open. How can I get data without ope...
excel
Monti20's avatar
Monti20
Copper Contributor
Apr 10, 2020

Hi  Abiola1 

thank you, it works if my data source is not in a table structure.

But it still refuses to work if my source data is in a table structure (a table with headers)

 

This is my cell content: 

=VLOOKUP([@Name];Data.xlsx!tabData[#Data];2;FALSE)

the table in the source workbook is called: tabData

obviously the worksheet name is not in the formula. Don't know why.

I can't interpret  the attribute [#Data]

Any ideas?

Thx.

Abiola1's avatar
Abiola1
MVP
Apr 10, 2020
[#Data] is the Structured Reference syntax of your VLOOKUP table_array argument. It is the same as your Table name
  • Monti20's avatar
    Monti20
    Copper Contributor
    Apr 10, 2020
    I see, thx.
    But I still get an #REF error as soon as I close the data file.
    The VLOOKUP seems not to work with structured table arrays

Resources