I have three Columns in my Excel File.
Col A is 'Code'. Col B is 'Group'. Col C is 'Item Number'.
I have the following data for each columns from Row 2 to Row 6.
Col A - Col B - Col C
Code - Group - Item Number.
4215 - Publications - 1
3726 - Publications - 2
4892 - Publications - 3
5364 - Medical - 1
2918 - Medical - 2
In D2, I type 'Publications', which is one of the Groups mentioned in Col B.
In E2, I type '2', which is one of the Item Numbers mentioned in Col C.
In F2, I have this array formula entered with Ctrl+Shift+Enter:
=INDEX(A2:A6,MATCH(1,(D2=B2:B6)*(E2=C2:C6),0))
This gives me the corresponding code '3726' and works fine on Computer.
But, in my Android Mobile, Ctrl+Shift+Enter is not possible.
Is there a solution for me to use this data in the Excel File on my mobile and get the expected result for the two criteria using this array formula or any other formula?
Please suggest. Thanks in advance.
Col A is 'Code'. Col B is 'Group'. Col C is 'Item Number'.
I have the following data for each columns from Row 2 to Row 6.
Col A - Col B - Col C
Code - Group - Item Number.
4215 - Publications - 1
3726 - Publications - 2
4892 - Publications - 3
5364 - Medical - 1
2918 - Medical - 2
Code | Group | Item Number |
4215 | Publications | 1 |
3726 | Publications | 2 |
4892 | Publications | 3 |
5364 | Medical | 1 |
2918 | Medical | 2 |
In E2, I type '2', which is one of the Item Numbers mentioned in Col C.
In F2, I have this array formula entered with Ctrl+Shift+Enter:
=INDEX(A2:A6,MATCH(1,(D2=B2:B6)*(E2=C2:C6),0))
This gives me the corresponding code '3726' and works fine on Computer.
But, in my Android Mobile, Ctrl+Shift+Enter is not possible.
Is there a solution for me to use this data in the Excel File on my mobile and get the expected result for the two criteria using this array formula or any other formula?
Please suggest. Thanks in advance.