CODEWITHSUNDEEP
google-sheets
Wing Tang
Wing Tang

Reputation: 1

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.

Upvotes: -1

Views: 1660

Answers (1)

player0
player0

Reputation: 1

The only way is to not use arrayed output but to have formula in each cell. Looking at your formula, you can't use A3:B7.

Upvotes: 0

Related Questions