1

I have this formula and want the reference to Archery to reference Archery which will be in Cell E1. I tried using the indirect formula but can't get it to work with the formatting for Google Sheets.

=QUERY(IMPORTRANGE("SheetLocation", "Archery!A4:E3000"),"SELECT Col3,Col2 WHERE Col1 like '%TRUE%'")
Improve this question

1 Answer 1

Reset to default
0

If E1 contains the word Archery you need to do this:

=QUERY(IMPORTRANGE("ID", E1&"!A4:E3000"), "select Col3,Col2 where Col1 like '%TRUE%'")

Improve this answer
0

Your Answer

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

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