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.