CODEWITHSUNDEEP
google-sheetsdrop-down-menu
user14953855
user14953855

Reputation:

How to alternate queries from drop down menu in Google Sheets

Hello Help Community,

I am trying to find a way to alternate queries from drop down menus. The idea is to be able to move between a list of queries and not have to rewrite the query when I want to use it again. I saw this done by writing the select statement in a drop down and referencing the cell containing the select statement in the query like this:

=QUERY(range, "" """"""&cell&"""""" "")

However, I cannot get this method to work. I can manipulate the same query using cell references and drop down menus but I would like to do more if it is possible.

Any idea how this could be achieved would be appreciated.

Regards, Andrew H"

Upvotes: 0

Views: 167

Answers (1)

player0
player0

Reputation: 1

example:

=QUERY(A2:D5, "where A = '"&B8&"'", 1)

enter image description here

if dropdown contains numbers use:

=QUERY(A2:D5, "where A = "&B8, 1)

Upvotes: 1

Related Questions