Forum Discussion

Copper Contributor

Apr 16, 2021

Solved

Index - Match External document

Dear All, I want to use the function Index & Match with 2 files. Everytime when I close my file and start the calculatin manually i get the errer message in the cell #VERW! (Dutch version). ...

excel

SergeiBaklan
Apr 16, 2021
Bthijssen

Thank you for the formula. Unfortunately references on tables don't work with closed file. The workaround could be as described here excel - Referencing a table in different workbook using IndexMatch or Vlookup only works when WB open - Stack Overflow . You may defined named range on the top of the table, i.e. if your second table with headers in A1:D20 you may define the name Range as $A$1:$D$100 to have some gap if table is expanded and work with it in formula.

NikolinoDE

Platinum Contributor

Apr 16, 2021

Bthijssen

How can I merge two or more tables?

You can merge (combine) rows from one table into another simply by pasting the data in the first empty cells below the target table. The table will increase in size to include the new rows. If the rows in both tables match up, you can merge the columns of one table with another—by pasting them in the first empty cells to the right of the table. In this case also, the table will increase to accommodate the new columns.

Hope I could help you with this information.

Nikolino

I know I don't know anything (Socrates)