Forum Discussion
UmairKamal
3 years agoHelper I
Lookupvalue bringing invalid dates
Dear Users, I have a table of payments and a table of cases. although there exists a one to many relationship, RELATED does not seem to be working. There are multiple payments for the same ca...
HotChilli
3 years agoCommunity Champion
This is a calculated column?
LOOKUPVALUE needs an odd number of parameters (there are 4 in the provided code).
It should be
(return value, search column1, search value1, search column2, search value2........
- UmairKamal3 years agoHelper I
the last expression in the code is for alternate result, that is why it is even number of parameters. considering the issue explained, you could advise me a better solution if the one I used is not.