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.