Referencing table in another workbook

[jwburrit]

Hello: I have a formula in a CurrentSheet that is looping through data looking at the headers of a data table (data_table) in the same workbook for index and match. That code works fine and is below. However, I need to make it refer to another data table in another workbook for the data. That table is named the same and has the same header structure. I've tried a ton of different ideas to make the reference work, but so far no luck.

Any help would be appreciated!

I posted this on another forum but couldn't get a solution!

Please Login or Register  to view this content.

[CK76]

You can't use structured reference to closed workbook.

Have a read of...
https://support.microsoft.com/en-ae/...es-display-ref

You could use range reference (i.e. address reference rather than structured table reference).

[jwburrit]

Thank you. But the workbook where the data table resides is open.

[CK76]

Then try adding workbook reference in front of table reference.

Ex:
='[WorkbookName.xlsx]SheetName'!TableName[ColumnName]

[jwburrit]

Thanks again. But that's where I'm stuck -- I can't get the data file syntax correct and I've tried a a bunch of different options.

[CK76]

If you follow above syntax. It should work.
Ex:

Please Login or Register  to view this content.

[jwburrit]

Thank you! Works perfectly.

[CK76]

You are welcome

If your issue is resolved. Please mark the thread as solved, using thread tools found at top of your initial post.

[jwburrit]

Will do. Thanks again.