[Solved] INDEX+MATCH

ROKTOBONDHU

New member
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....
 

Attachments

  • PRACTICE.xlsx
    9.6 KB · Views: 4
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....
Dear Roktobondhu

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.

Regards
Lutfor Rahman Shimanto
ExcelDemy
 

Online statistics

Members online
0
Guests online
14
Total visitors
14

Forum statistics

Threads
318
Messages
1,408
Members
583
Latest member
mibr fan token
Top