GOOGLE SHEETS

The user will just have to type the named range on the greyed cell without having to modify the query function.

QUERY SHEET// FRUIT TABLE

CodePudding user response：

With INDIRECT, i.e.:

=QUERY(INDIRECT(A3),"Select *")

I assume you'll be adding more to the Select clause. Otherwise (i.e. if you are wanting to pull the whole range without conditions), you can just use the INDIRECT function alone:

=INDIRECT(A3)