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?
Topic Participants
chrisd
Toolbox BSB Survey
Have you been using Toolbox BSB? We'd love to hear what you think!
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: