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 t...
Thanks for the responsed; really appreciated. How can I contact Microsoft Tech support? Does it matter that this is a software installation on my laptop used for work and not my home pc?
The way I contacted them: In Excel on the top ribbon there is a "Help" tab, there is an option "contact support". I'm not sure if it will be the same for 2019 though... There might be some legal issues if it's for your work, I'm not sure. They remotely logged onto my laptop to do the fix, not sure if your company will allow that? It all was very secure and professional though.
But all they did for me, and it work, was run an update....You can check it if you haven't yet. Go to File>Account> then there should be an update option, just click on that.
But all they did for me, and it work, was run an update....You can check it if you haven't yet. Go to File>Account> then there should be an update option, just click on that.
So, what happened? I am having a similar problem but I just assumed that I was not using my formulas correctly.
Skytalker Have a look in the previous comments, for me it was an update that the tech team did. but you can do it yourself (also mentioned in previous comments). Not sure if this will be the case for you but best to first check that.
