Microvellum Community

Best Practices: Material Thickness formulas

I've been thinking about this for a while. Perhaps it is somewhat irrelevant, since parts are drawn based on the material pointers used, but not all of the materials in a spec group are used in each cabinet. Sometimes I want to refer to a particular material (i.e. angled soffit veneer) within another cabinet (i.e. tall or upper).

So, let's say I have a pointer: Angled_Soffit_Veneer and want to grab the material thickness in a formula
(without adding a prompt). Which would you all tend to use:
  1. =M!Angled_Soffit_Veneer_Thickness
  2. =VLOOKUP(M!Angled_Soffit_Veneer,M!MFSH,2,FALSE)
The first is slightly cleaner, but is the second more robust?

    Toolbox BSB Survey



    Have you been using Toolbox BSB? We'd love to hear what you think!

    Take the Survey

      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.