CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formulaarray-formulas
DAK7
DAK7

Reputation: 83

Construct a Query to Reference Indirect Array

So I have this formula

=ARRAYFORMULA(INDIRECT("Data!A"&13+$F$7&":A"&597+$F$7))

to reference dates in another sheet Data!. I just submitted a separate request here which is similar.

Difference in this case is I need it to return the entire array. First part would likely be the following, but I have no clue what the query language ought to be. Thank you for your help.

=QUERY(
  OFFSET(INDIRECT("Data!E13"), $F$7, 0, 597 - 13 + 1, 1),
 Query language
)

Upvotes: 1

Views: 85

Answers (1)

kishkin
kishkin

Reputation: 5325

Just use:

=OFFSET(INDIRECT("Data!E13"), $F$7, 0, 597 - 13 + 1, 1)

Upvotes: 2

Related Questions