L
L
luckyness2020-06-06 10:21:49
Google Sheets
luckyness, 2020-06-06 10:21:49

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

1 answer(s)
G
Grigory Boev, 2020-06-06
@luckyness

Use INDIRECT () aka INDIRECT ()
=ДВССЫЛ("workdays_"&A1)

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question