How to use cell references with words, numbers, and dates in Google Sheets QUERY function

Using a cell reference with Google Sheets QUERY function will allow you to create a dynamic environment to explore a dataset. This video will touch on how to use a cell reference when querying a word, number, or date.
Timestamps
4:01: Using a cell reference in a QUERY function
5:42: How to use a cell reference with a number in a QUERY function
9:08: Explaining how cell references work in a QUERY function
10:39: How to use a cell reference with a date in a QUERY function
21:21: How to use a cell reference when your string has an apostrophe
My channel focuses creating lessons to help people learn how to work with data. The intention of these videos is to explain the fundamentals so that you can build data projects.
The main goal of this series is to get viewers to a point where they can attempt my beginner dashboard build. You can find a link to it here: • How to build a dashboa...
You can also check out the playlist for this series here: • Google Sheets Dashboar...
If you're interested in ways to lookup data then you can find it here: • How to lookup data in ...
If you're interested in learning about the most powerful function in Google Sheets then you can find it here: • How to use QUERY in Go...
Here is a sample set of data you can use to follow along with the lesson. Please make a copy and add to your Google Drive: docs.google.co...

[@parkhyomi07]

Brilliant! Thank you so much for the super clear, useful and detailed explanation!!!

[@mattbrigidi]

it's my pleasure! i'm so happy to hear that you found it helpful!

[@mickleberry]

This really helped me make sense of the whole Query thing, thank you Matt, much appreciated 😺

[@mattbrigidi]

i’m glad to hear it!

[@JerryPick-k5p]

Excellent explanations!!!

[@mattbrigidi]

that’s so kind of you to say

[@SanthoshKumar-e5t]

Thank you! This helped me to solve my issue.

[@mattbrigidi]

i’m so glad to hear that! thank you for reaching out

[@lafamillecarrington]

Beautifully clear explanations, thanks.
How do you view all the data if you have a link to a cell for a query?

[@mattbrigidi]

Thank you for the kind words - I use a combination of the JOIN function along with IF. Most times that looks like this:
WHERE A is not null
"&
JOIN(" ",
IF(C2="All","","AND A = '"&C2&"'"),
IF(E2="All","","AND B = '"&E2&"'"))
&"
I use "WHERE A is not null" so that I have a clause to pass to the WHERE statement (I recently started using WHERE 1=1 bc its logically and doesn't impact my computation). The JOIN adds in a blank space so if my cell reference is set to "All" then and that gets passed is " ".
The IF statements allow for the following conditions:
1. IF the cell reference is "All" then return null
2. Otherwise return "AND {Column Letter} = '"&{Cell_reference}"

[@lafamillecarrington]

@@mattbrigidi That should let me make my Repair Cafe booking form much more usable than it is at the moment. Thanks again.

[@michaelrusso2535]

This is great! Question - how would I get the query to populate multiple rows based on date. In other words, instead of it having a single row with agg. data constrained within the date values, I'd like the query to populate multiple rows displaying data for each day, week, etc. of the date range.

[@mattbrigidi]

thank you! it depends on the specifics of your data - i have a whole playlist about query: How to use QUERY in Google Sheets
ruclips.net/p/PL_xiAt6o4ZXyQn8xkOCMfgdUlu36ZOkYB
let me know if you have any questions and i’ll be happy to help