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))
Best Answer
Functions that return an array like QUERY can't be "used" on an ARRAYFORMULA as it already returns an array of values.