Microvellum Knowledge Network

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!

    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