Add-ons
Check out the store for many more
Add-on

3D Reference


(2)
offered by jackcarey.co.uk
737 users

Overview

Custom functions that output a 2D array from a common range across multiple sheets.
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.
​

Details

Version: 15
Updated: August 16, 2018
Language: English