What does this formula mean in excel? (Cell equals range)

Question

I see the following formula in an excel spreadsheet and I can’t understand ... Can someone explain what the check condition "N5 = N4: N741" means?

=MIN(IF(N5=N4:N741,K4:K741))

I did some experiments and still can not understand ...

Answer 1

I assume this is an array formula.

This means that the minimum range is K4: K741, where the value in N4: N741 is equal to the value in N5.

Let's look at a smaller example. K4: N9 is shown below.

    K L M N 
  ----------
4 | 4     2
5 | 8     7
6 | 3     4
7 | 2     1
8 | 7     9
9 | 1     7

N5=N4:N9 5 9, N5 (value = 7), {False,True,False,False,False,True} , IF(N5=N4:N9,K4:K9) {False,8,False,False,False,1}, True ​​ K. MIN() False K ( 1 1 8).

Answer 2

, . , 3, . .

{false, false, true, false, false}

5 E1 1, true.