Custom functions that output a 2D array from a common range across multiple sheets.
Listing updated:November 29, 2023
Works with:
14K+
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.
​
Additional information
PricingFree of charge
Developer
Non-trader
Privacy policy
Terms of service
3D Reference will ask for the permissions shown below. Learn more
3D Reference will need access to your Google account
This will allow 3D Reference to :
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Loading
Search
Clear search
Close search
Google apps
Main menu