Answer the question
In order to leave comments, you need to log in
Is it possible to use a cell reference in a query?
Good time!
It is necessary in the query
=QUERY({workdays_2020}; "SELECT Col3 WHERE Col2 LIKE '"&B7&"' ";-1)
instead of workdays_2020 (this is a named range) use workdays_A1 where A1 is a cell in the table that contains a specific year.
Is it possible to somehow pass this to QUERY?
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question