FEATURE REQUEST: User-Defined Functions
Please let me know if this ability already exists -
I would love to be able to create my own user-defined functions that could then be used throughout MV's many workbooks. MV has GETBULGE, GETARCRADIUS, etc. that make formulas much simpler, and I'd like to be able to make my own versions of that type of function.
I would love to be able to create my own user-defined functions that could then be used throughout MV's many workbooks. MV has GETBULGE, GETARCRADIUS, etc. that make formulas much simpler, and I'd like to be able to make my own versions of that type of function.
An example of somewhere I would use this would be the following:
- The user chooses a "Material" in the wizard.
- That is used in an Index/Match to lookup a "Material_Type" from one table.
- That "Material_Type" is then used inside of another Index/Match to lookup the "Tool_Number".
=INDEX(LookupTable_Tool,MATCH(INDEX(LookupTable_Material,MATCH(Material,LookupTable_Material_Column1,0),MATCH("Material_Type",LookupTable_Material_Row1,0)),LookupTable_Tool_Column1,0),MATCH("Tool_Number",LookupTable_Tool_Row1,0))
I would rather be able to make a function called "GetToolFromMaterial", which would instead make that longer formula look like:
- The user chooses a "Material" in the wizard.
- That is used in an Index/Match to lookup a "Material_Type" from one table.
- That "Material_Type" is then used inside of another Index/Match to lookup the "Tool_Number".
=INDEX(LookupTable_Tool,MATCH(INDEX(LookupTable_Material,MATCH(Material,LookupTable_Material_Column1,0),MATCH("Material_Type",LookupTable_Material_Row1,0)),LookupTable_Tool_Column1,0),MATCH("Tool_Number",LookupTable_Tool_Row1,0))
I would rather be able to make a function called "GetToolFromMaterial", which would instead make that longer formula look like:
=GetToolFromMaterial(Material)
The function would be set up to take the input (Material) and run it through the double index/match automatically.
Topic Participants
Sara Johnson
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: