Dynamic INDIRECT function
In this tip, we are going to explore:
Dynamic INDIRECT function
All explanations are simple and to the point.
#Shorts #GoogleForEducation #GoogleWorkspace #GoogleSheets
Feel free to make your copy of this spreadsheet template:
https://docs.google.com/spreadsheets/...
Useful Link:
Google Workspace Tutorial:
/ googleworkspacetutorial
Ben Collins (Google Developer Expert & Data Analytics Instructor)
https://www.benlcollins.com/
Google Sheets training:
https://support.google.com/a/users/an...
The Playlist link:
• The most useful Google Apps Tips and ...
Follow us on Pinterest:
https://www.pinterest.it/GoogleWorksp...
In this sheet, we have the results of the first exam.
And in this one, we have the results of the second exam.
Our mission is by selecting the sheet name, we get its data.
To achieve that, we use this formula:
=INDIRECT("'"&A1&"'!A2:B")
Here is the drop-down menu cell.
We add it between "&&"
The sheet name is surrounded by single quotation marks.
And we surround all with double quotation marks.
