LOOKUP if one of the columns filled in by the user matches

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

0 16 738
16 REPLIES 16
Top Labels in this Space