1

Trying to make an ARRAYFORMULA that executes a query function which takes a reference to the current position of the row number and the specified column name.
This is my version of formula:

=ARRAYFORMULA(QUERY(DB!A:H,"select G where A="&address(TEXT(ROW(C:C),"B0")),1))
4
  • What is your question?
    – slybloty
    Dec 17, 2018 at 21:44
  • to create a formula that applies to the whole column and it take row address of the current row Dec 18, 2018 at 8:13
  • 1
    You'll have to be more specific in your post. State what you want to achieve, what you've done, and what issues you have.
    – slybloty
    Dec 18, 2018 at 17:15
  • hi i am trying to write a formula which can take up the reference of the current row/ cell address and perform a query and return the output. I want to apply this formula to the whole column Dec 27, 2018 at 9:06

1 Answer 1

0

Functions that return an array like QUERY can't be "used" on an ARRAYFORMULA as it already returns an array of values.

1
  • what can be done to apply a formula to the while column. the condition being as the cell value changes going down the column the formula should take up the row/cell address and apply the formula. Dec 27, 2018 at 9:04

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.