Microvellum Community

Formula Help - works in Legacy Library but not Foundation Library

We are setting up our Foundation Library and are bringing over our Lookup Table for all of our in house custom moldings we make and I am running into the issue where the following formula no longer works in the Foundation Library like it currently works in the Legacy "Component" Library. 

The formula:

=INDEX(M!MFSO_Name,MATCH(AD2317&" - "&M!WD_Finish_Selection&"*",M!MFSO_Name,0))


The lookuptable value it creates currently in Legacy Library:




Any information or direction on how to fix this would be great.

    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.