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.)
Solved! Go to Solution.
got it working... if the lookup does not find any item how can I display a message in the 'value' ?
if(IsNullOrEmpty(lookup(....)),"No Value",lookup(....))
yes it did thank you.. :)