Emil
Emil

Reputation: 59

Substituting a value for a reference

I feel like this should have a simple answer. I have the following formula:

=query(DATA, "select * where A='Tues'")

I want it to reference the contents of a specific cell to use as a filter, for example A1, instead of manually inputting the filter ('Tues' for example) into the formula when I want to change it. Thank you!

Upvotes: 0

Views: 71

Answers (2)

player0
player0

Reputation: 1

or try:

=FILTER(DATA, DATA!A:A=A1)

Upvotes: 0

Harun24hr
Harun24hr

Reputation: 36780

Try-

=QUERY(DATA,"select * where A='" & A1 & "'")

Upvotes: 2

Related Questions