AnsweredAssumed Answered

Using a concatenated calculated value to perform list lookup

Question asked by pam.lewis@us.atlascopco.com on Sep 21, 2017
Latest reply on Oct 6, 2017 by emha

I have 2 concatenated calculated value fields,  cvaA & cvaAA in List A and a concatenated calculated value field, cvaB, in List B.  In both lists the concatenated values are the same types of information (single line text).  I want to use the value cvaA to lookup in List B to return the value in column SerialNumber.  Is this possible to do?

The user enters values into 2 fields thus the concatenation being done in cvaA of List A.

I have a Lookup defined on the calculated value field - cvaAA :  lookup("Certs", "cvaB", cvaAA, "SerialNumber")

Not working I receive  #value!  on the form.

 

(List B does have the same values in its concatenated calculated value field for lookup testing.)

Outcomes