So I have this formula:

At a high level, the formula goes like this:

If [Dynamic Array #1] = False, 0,

    Index(
        If [Dynamic Array #2] = 1, Named Range A, Named Range B    <-- Problem exists here
        Row,
        Column
    )

There’s a Dynamic Array with ones and zeroes, and the formula should be using that to choose which named range it’s going to index.

But the formula is always indexing Named Range A, and never Named Range B, even when the value means it should be.

Why?