P
P
partyzanx2019-08-30 09:29:27
excel
partyzanx, 2019-08-30 09:29:27

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

2 answer(s)
B
Bcoon, 2019-08-30
@partyzanx

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)));"")

A
Anton Fedoryan, 2019-08-30
@AnnTHony

И(C="ВЗР";D="БИЗНЕС")
AND() function in MS Excel

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question