I have Lookup returning a couple of results into a separate page. Three out of the four cell return the exact value I am looking for, but the fifth one is not.
The first three columns are Product Name, Product Form, QTY. They are pulling information that is either entered directly into the referenced cell or a simple link (i.e cell b12 = b11.)
The fourth cell is a 44 digit GS1 code that is displayed correctly in the cell I am trying to look it up it from, but the displayed code in that cell is put together using: eg "=CONCAT("(01)",N142,"(13)",H142,"(10)",J142)"
When it display the lookup, I am only getting (in this example) H142 and J142 returned properly. N142 is itself a CONCAT: eg "=CONCAT("00",K171,L171)", but the output is displayed as 00.
The first three columns are Product Name, Product Form, QTY. They are pulling information that is either entered directly into the referenced cell or a simple link (i.e cell b12 = b11.)
The fourth cell is a 44 digit GS1 code that is displayed correctly in the cell I am trying to look it up it from, but the displayed code in that cell is put together using: eg "=CONCAT("(01)",N142,"(13)",H142,"(10)",J142)"
When it display the lookup, I am only getting (in this example) H142 and J142 returned properly. N142 is itself a CONCAT: eg "=CONCAT("00",K171,L171)", but the output is displayed as 00.