gnaga
Well-known Member
- Joined
- Jul 9, 2002
- Messages
- 748
- Office Version
- 365
- 2016
- 2013
- Platform
- Windows
Hi,
I am using Index Function in arrray formula.My formula is as follows
{=Index(A1:D3,A4)}
A4 is housing a number 2
I am entering this formula in the range of
E1:E4
It suppose to return the value of A2:D2 asper excel doumentation. But it is repeating the value of A2 in all the cells in the range of E1:E4.
If my understanding is right then why it is not returning the value? Otherwise what is it I am missing?
Please help me.
GNaga
I am using Index Function in arrray formula.My formula is as follows
{=Index(A1:D3,A4)}
A4 is housing a number 2
I am entering this formula in the range of
E1:E4
It suppose to return the value of A2:D2 asper excel doumentation. But it is repeating the value of A2 in all the cells in the range of E1:E4.
If my understanding is right then why it is not returning the value? Otherwise what is it I am missing?
Please help me.
GNaga