Forum Discussion
Excel 2019 index match formula not working with multiple workbooks
I've been using the function combination of INDEX and MATCH to retrieve data from multiple workbooks for some time now, but now that I'm using Excel 2019, I cannot access other workbooks when I try to use the formula and select an array in another workbook. This also happens when I try to use VLOOKUP; it won't let me access other workbooks to select the array.
10 Replies
- Hello all! Sorry I haven’t gotten back on this sooner; it’s been pretty hectic! My tech support team at work was able to resolve with a Microsoft update that took care of the problem. If you’re still having the issue, please check with your system administrator or tech support team, and have them make sure that all recent updates have been installed on your PC or laptop.
Excelsior! grgrobin1206 have you found a solution? I just upgraded from 2013 to 365 and I'm having the same problem. I can use match and select an array in a different workbook...
- No yet; hoping that someone else in the Tech Community has come up with a solution. Thanks for the feedback, hynguyen. Is it possible that a setting in Excel 2019 needs to be changed?
grgrobin1206 I do not think I have ever changed Excel default settings since installing it. Sorry that you've got that problem. Hope Tech support may help you to figure it out.
grgrobin1206 I don't think that it is because Excel 2019. I am using Excel 2019 and I can use Vlookup, Index/match to find info from other closed workbooks just fine
