CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formulaarray-formulas
alesdario
alesdario

Reputation: 1894

In ARRAY_LITERAL, an Array Literal was missing values for one or more rows - indirect formula error in google spreadsheet

Hy Guys, i'm triyng to merge two different Tab of the same Google SpreadSheet.

I'm using this formula in the first cell

={indirect(dynamicRange1);indirect(dynamicRange2)}

where dynamicRange 1 and 2 are:

But shomething does not work fine.

"In ARRAY_LITERAL, an Array Literal was missing values for one or more rows"

If i use just one dynamicRance everything works fine, both something goes wrong.

Upvotes: 11

Views: 149506

Answers (3)

nelsonmau
nelsonmau

Reputation: 61

You need same number of columns in all arrays. You should keep the same number of columns in all imported sheets, even if you have empty columns. Deleting empty column in at least one sheet will cause an error.

Upvotes: 1

UTF Forms
UTF Forms

Reputation: 81

This error is generated when the number of columns in two array is not the same:

In ARRAY_LITERAL, an array literal was missing values for one or more rows

You need same number of columns in all arrays.

Upvotes: 8

TheMaster
TheMaster

Reputation: 50462

Number of columns in both sheets must be the same:

Try 

={Sheet1!A2:D10;Sheet2!A2:D10}

Upvotes: 18

Related Questions