Google Sheets Query with Indirect Address

Question

I am running into issues with this query and am unsure of what is going wrong.

I tried various formatting setups but nothing seems to work.

https://docs.google.com/spreadsheets/d/15GkrohT_eCuJOtUYvoLaCWMeGJ5rauF0Duj-fBxPNBg/edit?usp=sharing

I am trying to have imported data be queried and organized to then be pulled into a weekly format on 'TestingMain'.

Any and all help would be greatly appreciated.

user_15085200 · Answer

I did not solved the problem per se, but I found a work around. The problem lay in the first leg of the WHERE clause so instead of having the indirect address formula, I just had a different string for each row.

ifna(QUERY(Testing2!$A:$F,"select E where A='one' AND B= date '" &TEXT(DATEVALUE(E2),"yyyy-mm-dd")& "' ",0), 0)

Google Sheets Query with Indirect Address

1 Answers