Google Sheets Formula Import Range with Indirect

Posted on

Whether you’re just starting out with Google Sheets or are a seasoned pro, sooner or later one of your formulas will give you a formula parse error message rather than the result you want. However, every Formula user, irrespective of whether it’s a beginner or expert, has invariably come across a formula parse error in Google Sheets at least once in their life (and if you haven’t. you soon will). It can be frustrating, especially if it’s a longer formula where the formula parse error may not be obvious. In this article, we will talk about some common formula parse errors in Google Sheets, like Google Sheets Formula Import Range with Indirect, and how to fix it.

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

Answer :

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

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