2 мая 2013 г. · You can use INDIRECT to dynamically refer to sheetnames like this in your example: =INDIRECT(CONCATENATE(A1;"!B2")) Call A1 should contain your year number.

8 сент. 2023 г. · INDIRECT is the way, no other option. Possibly the concatenation of text was the issue =countifs(INDIRECT(A1&"!$A:$A"), $A8, INDIRECT(A1&"!

29 сент. 2023 г. · Create a filter that will allow me to change which sheet I am referencing in a query or filter function.

4 мая 2023 г. · Here is the code that will work for you. For getting sheet name automatically from column A cell: =TRANSPOSE(indirect(A1&"!$B$1:$C$13"))

15 янв. 2019 г. · I am attempting to use a query to display data off multiple Google Sheets. I make a new sheet every week that has a specific sheet name.

29 нояб. 2018 г. · The indirect formula is definitely what you want! It should be =indirect(A1&"!$A$100"). If the tab name has a space, it might have to be =indirect("'"&A1&"'!$A$

5 февр. 2019 г. · This question is asked for the sake of understanding how to pass a variable range into a filter function (if it's possible).

13 февр. 2013 г. · In Google spreadsheet I want to query data in another sheet ... Basically I am getting name of the sheet using INDIRECT("Overview!L5 ...

18 дек. 2015 г. · I want to recall values from the same cell address from the same workbook from different sheets (tabs) I am returning the values to a different workbook.

11 окт. 2014 г. · Yes, by using the INDIRECT function: A1: Sales Report - WB 10.06 Then you can use: =INDIRECT("'"&A1&"'!B3")