index function error using match function to get data from a cell in an array

[mabildgaard]

Hi All,

I am using the below function to obtain data from a single cell in an array.

=INDEX(AD13:AP27, MATCH(F4,AD13:AD27), MATCH(F12,AD13:AP13))

The function works 80% of the time. It occasionally goes brain dead and selects the wrong column. The function resides in Cell I13 on tab G01.

Can someone help me? I believe the problem may exist within Excel.

Thanks,
Mark

[martindwilson]

try
=INDEX(AD13:AP27, MATCH(F4,AD13:AD27,0), MATCH(F12,AD13:AP13,0))

[mabildgaard]

That worked. Thank you.

[sanjeev410]

I have a similar problem, i am using * as one of the value to get Particular against that Code.
=INDEX(D:D,MATCH(C9,E:E,0),1)
and getting
C D (these are the columns)
* Particular (these is where function used)

A B C D E (these are the columns)
Number Acc ID Particular Code (these are the columns headings)
1 ABC 66 HR Management #
2 DEF 22 Travell Management $
3 JKL 88 Corporate Management *
4 MNO 77 WH&S Management {
5 RST 33 ICT Management )

any idea?

[arlu1201]

sanjeev,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.