Forum Discussion
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 opening the data source file?
thx
4 Replies
- Hello, I believe it should work fine if the workbook isn't opened. You gonna need to accurately provide the workbook name, sheet name and the cell reference in your VLOOKUP formula
However, since you can do the VLOOKUP when the two workbooks is opened, I think there is no reason to try to stress the brain as much
You can check the link below
https://m.youtube.com/watch?v=6pSYP2plbdI
CheersHi 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.
- [#Data] is the Structured Reference syntax of your VLOOKUP table_array argument. It is the same as your Table name
