Construct a Query to Reference Indirect Array

Question

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
)

kishkin · Accepted Answer · 2020-04-30 10:11:04Z

2

Just use:

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

answered Apr 30, 2020 at 10:11

kishkin

5,3551 gold badge28 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Construct a Query to Reference Indirect Array

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related