'Fix #REF! "Array result was not expanded because it would overwrite data" without having to remove data
Wonder is there a way to fix the aforementioned #REF! without having to remove data in the cell that blocks the expansion. I used INDEX, MATCH, HLOOKUP and IMPORTRANGE in the formula, click here to see the full formula.
Solution 1:[1]
the only way is to not use arrayed output but to have formula in each cell. looking at your formula you cant use A3:B7
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | player0 |