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.)