Could a function be added for returning the LookupTable a cell is currently in? Similar to COLUMN() and ROW(). An example use for this function would be in the VLOOKUP formula: VLOOKUP("Text",LOOKUPTABLE(),COLUMN(),FALSE).
MVU eLearning
Grow Your Knowledge
Follow along with RJ as he takes you on a journey to build your foundational knowledge of Toolbox.
Follow us on:
ERP for Millwork Shops
Discover how Microvellum and INNERGY streamline operations for cabinet shops and millwork manufacturers.