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.

    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.