Microvellum Knowledge Network

How do Stored Formulas work?

In the Workbook Designer under 'Edit' you can find Stored Formulas which allows you to make a formula and give it a name. How is this used? Can you make a formula to perform a common calculation you will need, and it will take different inputs based on how you call it? And how do you reference a formula into a cell once created?

I.e., say I have VLOOKUP("Row_Name",S!Subassembly_Table,MATCH("Column_Name",S!Subassembly_Table_Header,0),FALSE)

This VLOOKUP-MATCH combination is repeated often in my workbooks. If I create a Stored Formula, can I make Row_Name and Column_Name a variable?

    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:

               

        Google Review