This error occurs when the function generates an array of results, but some of the required cells are not empty. When you roll over the cell with the #REF error, you’ll see a pop-up message: “Array result was not expanded because it would overwrite data in D3” (where D3 is an example of the referenced cell).
To resolve the #REF error, it’s important to ensure that any cells mentioned in the error message are empty. Clearing the referenced cells will allow the function to expand and populate the array result correctly, eliminating the #REF error.
