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

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

That worked. Thank you.

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?