Hinge Plates and Vlookup tables

Hinge Plates and Vlookup tables

How do you know which hinge plate you are using for a hinge?

Here are my equations:
=VLOOKUP(Hinge_Overlay_Left_Calc,LookUpTableHingePlates,16,TRUE)+(17.5/Unit_Divisor)
=VLOOKUP(Hinge_Overlay_Left_Calc,LookUpTableHingePlates,12,TRUE)


The first equation get the value in column 16 from the hinge plate name in column 12 from the second equation. All the hinge plate names in column 12 are all the same. The values in column 16 vary. I want to know is there a way I can say "it that value" without guessing? 

    MVU eLearning



    Are You Ready to Streamline the Way You Learn?
    Follow along with RJ as he takes you on a journey to build your foundational knowledge of Toolbox.


      Follow us on: