Good afternoon, first I thank you in advance for your help.
Please could you give me an expression to be able to obtain the value of a column in a table if any data from 4 columns of another table matches.
The user must complete this information in a form and if any data from this list matches
Identification document,
Email,
Telephone,
Mobile phone
The expression must search in another table under the name Pre-Approval Data and bring the result from the Agent Code column.
please could you help me with this expression since I have tried but I cannot understand very well this expression of LOOKUP for the search of various data
User | Count |
---|---|
41 | |
36 | |
28 | |
23 | |
16 |