Answer the question
In order to leave comments, you need to log in
How to add 2 conditions and not 1 during array creation?
There is a line like this
=IFERROR(INDEX(B:B,SMALL(IF($C$11:$C$60="VZR",ROW($C$11:$C$60)),ROW(1:1)));" ")
Provided that in cell C="VZR", then the cell from column B is displayed.
How to do the same, but only if there are two conditions, i.e. C="VZR" and D="BUSINESS"
Answer the question
In order to leave comments, you need to log in
Like this:
=IFERROR(INDEX(B:B,MINIMUM(IF( ($C$11:$C$60="VZR")*($D$11:$D$60="BUSINESS") ;ROW($C$11: $C$60));STRING(1:1)));"")
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question