I am trying to use this formula INDEX(MATCH)... But it's not working for me for some reason... I am using 2016 version of office 365 on my pc... When I used the same formula on my mobile it is working....
I am trying to use this formula INDEX(MATCH)... But it's not working for me for some reason... I am using 2016 version of office 365 on my pc... When I used the same formula on my mobile it is working....
Welcome to ExcelDemy Forum! Thanks for reaching out and sharing your problem.
You are facing difficulties with an INDEX-MATCH formula. You mentioned that it works on your mobile device but not your PC, which uses Excel 2016.
I have reviewed your formula and found that it is an array formula. In Excel 2016, array formulas need to be entered using Ctrl+Shift+Enter, not just Enter. On the other hand, Mobile versions of Excel, especially in newer releases, may have built-in functionality to handle specific array formulas.
I hope these ideas will help you overcome your situation. Good luck.