What exactly do you have in your table? Sounds like you have 4 columns: Address_1, Address_2, Address_3 and a preferred column...
Please explain how the preferred column indicates which of the other 3 columns it is.
If you have a preferred option per adress column it would be something like:
if table.preferred1field=true then table.address1 else
if table.preferred2field=true then table.address2 else
if table.preferred3field=true then table.address3 else
'Missing Preferred address text here' (this last else is optional to capture instances where none of the above are true, otherwise it would be an empty string).
IP Logged
