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))

bumped to the homepage by Community 2 days ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

  • What is your question? – slybloty Dec 17 '18 at 21:44
  • to create a formula that applies to the whole column and it take row address of the current row – tinker shukla Dec 18 '18 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 '18 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 – tinker shukla Dec 27 '18 at 9:06

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

  • 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. – tinker shukla Dec 27 '18 at 9:04

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

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