Background: The pink and blue shaded cells are commodity codes that have leading zeroes or are alpha-numeric codes. Our system rejects these types of codes and we require either a replacement code from the CONSOLIDATED TAXONOMY FILE or if no other alternative code is available, we have to generate a new commodity code (I will do this part). The lookup value is the NEW COMMODITY NAME (Column H), the results from the formula can be placed horizontally beginning at (Column U) ALTERNATE VISION COMMODITY CODE in the “ASM TAXONOMY FILE 040616”.
The range where the possible return matches is can be found in the tab “CONSOLIDATED TAXONOMY FILE”, using COMMODITY (Column G) and returning the value COMMODITY CODE (Column H). There is a possibility that there is only 1 commodity code choice which may be the leading zero or alpha-numeric code we are already using – I need to validate this.