Using a concatenated calculated value to perform list lookup

[pam_lewis]

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

[emha]

yes, this should be possible.

if you get value error, it looks like formula definition/syntax is not correct. check correct spellings/names of list and fields.

is the list being looked up on the same site as the list on which you run the form?

‌ lookup function‌ ‌ ‌ no value returned‌

[pam_lewis]

got it working...    if the lookup does not find any item how can I display a message in the 'value' ?

[emha · Accepted solution]

if(IsNullOrEmpty(lookup(....)),"No Value",lookup(....))

[emha]

Hi ‌, did it help?

have you managed to get it working?

[pam_lewis]

yes  it did thank you.. :)

[emha]

great!

can you mark correct answer?

‌