I have a workbook with a sheet that makes use of INDEX and MATCH to look up values in another workbook.
Problem is I always get #REF errors when I open it. I assume this is because the external workbook the formulas refer to is closed, cos when I open said workbook, it works fine.
I tried using VLOOKUP instead, same problem.
Is there any way at all round this?
I'm using Excel 2010.
Also posted here: http://www.ozgrid.com/forum/showthread.php?t=199563&p=769811#post769811
Many thanks.
Problem is I always get #REF errors when I open it. I assume this is because the external workbook the formulas refer to is closed, cos when I open said workbook, it works fine.
I tried using VLOOKUP instead, same problem.
Is there any way at all round this?
I'm using Excel 2010.
Also posted here: http://www.ozgrid.com/forum/showthread.php?t=199563&p=769811#post769811
Many thanks.
Last edited: