• 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

  • Book1.xlsx
    142.4 KB · Views: 8
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

  • Book1.xlsx
    143 KB · Views: 4
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
 
Back
Top