Help & Support
Send Feedback
3D Reference
Custom functions that output a 2D array from a common range across multiple sheets.
jackcarey.co.uk
50 users
Works with
Install
Overview
This add-on adds two functions that both output a 2D array containing values from a common range across multiple sheets. The basic function takes sheets based on their name and the advanced function will iterate through numbered sheets at a configurable step, or use regex match to find matching sheets. These functions allow you to reference multiple sheets at once, without having to add them to your formula manually.
​
Reviews
February 20, 2018
Kamil Jaszkowiak
Submit reply
Cancel
1-1 of 1
Additional information
Search
Clear search
Close search
Google apps
Main menu