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%'")

1 Answer 1


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

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


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.