Multiple IFERROR with INDEX Formula

[cyliyu]

I can't get the multiple Iferror with Index formula works in my spreadsheet and need some help.

The sequence will be:-
1) Check column "O" first, if "scrap" then output "scrap" at column "G"
and Ignore others, "e.g. Working".
3) follow by check column "N" and display accordingly.

Thanks

 

[Nebu]

Hi:

May be this?

=IFERROR(IF(INDEX($O$5:$O$9,MATCH(1,MMULT((E5=$L$5:$L$9)*(F5=$M$5:$M$9),1),0))="Scrap","Scrap",INDEX($N$5:$N$9,MATCH(1,MMULT((E5=$L$5:$L$9)*(F5=$M$5:$M$9),1),0))),"Not Found")

Thanks

 

[cyliyu]

Thanks, Nebu.
It works in my master worksheet.

 

[bosco_yip]

Another option,

In G5, copied down :

=IF(AND(E5="",F5=""),"",TEXT(IF(INDEX(O$5:O$1312,SUMIFS(K:K,L:L,E5,M:M,F5))="Scrap","Scrap",INDEX(N$5:N$1312,SUMIFS(K:K,L:L,E5,M:M,F5))),";;""Not found"";@"))

Regards
Bosco

 

[cyliyu]

Thanks, Bosco.
This option works well too.