Microvellum Community

Problem of Vlookup Formula

Hi,

I am messing around with adding custom pulls and trying to figure out location of it. Can't see why the Vlookup formula doesn't return the right value(-0.01). 
=(INDIRECT(PARENTNAME("Door_Thickness"))*-1)-VLOOKUP(Pull_Name_Door,G!LookUpTablePullType,9,FALSE)
The Lookup Table and the formula are both the same as in our old library (MV67) currently used, I copied those in the new library(v50.7) but it doesn't work here.  I am attaching the formula and lookup table below. Anyone see an issue here?

Also, a couple of other questions relating to my problem:

  1. What does Function Parentname do here? = Indirect (Parentname("Door_Thickness"))*-1 .I saw in the new library it is simply used as = Door_thickness *-1
  1. The Lookup Table Pull Type is only shown in the graphic interface ( attached MISC1) but not in the spreadsheet interface (Misc 2).  But when i click on the  Lookup Table Pull Type Auto Size in the speadsheet interface, it leads to the former lookup table. Is it a glitch of the new library? 
Thank you!

    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.