• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Multiple IFERROR with INDEX Formula

cyliyu

Member
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
 

Attachments

Nebu

Excel Ninja
Hi:

May be this?
Code:
=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
 

Attachments

bosco_yip

Excel Ninja
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
 
Top