ERROR in my INDEX MATCH Formula

**znalron@yahoo.com** · 03-13-2013, 02:32 PM

Good Day Everyone!

Please see attachment regarding my INDEX MATCH formula. It does not return a correct figure. I matched column A of both sheet, I couldn't found the error. Please Help!

**martindwilson** · 03-13-2013, 02:51 PM

use this non array instead
=INDEX(Sheet1!$L$2:$L$12,MATCH(A14&K14&$O$8,INDEX(Sheet1!$A$2:$A$12&Sheet1!$D$2:$D$12&Sheet1!$C$2:$C$12,0),0))

fwiw the array formula should be
{=INDEX(Sheet1!$L$2:$L$12,MATCH(A14&K14&$O$8,Sheet1!$A$2:$A$12&Sheet1!$D$2:$D$12&Sheet1!$C$2:$C$12,0),0)}