Jun 16 2020 01:25 PM
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.
Jun 16 2020 05:56 PM
@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
Jun 17 2020 05:29 AM
@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...
Jun 17 2020 06:04 AM
Jun 17 2020 06:32 AM
@grgrobin1206 I just had Microsoft tech support have a look for me. On my side, it was only an update that I had to run (which I should've probably checked first of all, but I only installed 365 2 days ago, so I thought it would've been the latest updates). I'm not sure if you can do updates with 2019, but maybe worth having a look.
Jun 17 2020 06:31 PM
@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.
Jun 18 2020 06:22 AM
Jun 18 2020 06:29 AM
Jan 24 2021 09:22 PM
So, what happened? I am having a similar problem but I just assumed that I was not using my formulas correctly.
Feb 01 2021 05:26 AM
@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.
Feb 01 2021 05:39 AM