Lookup, return data and add reference to row title

[Anders_Berg_Christiansen1]

Hi everyone,

I am trying to autopopulate fields in a table based on the selections in a lookup-column in the same table. In essense the same as here:

Return data from fields in same row after lookup

HI guys and girls Can anyone pls tell me how, if I select a field with a lookup field (ie: Full Name) how I then get the system to populate 2 other fields I have Email and Phone with the email and phone from the table teh lookup was aimed at.

I use the same formula structure as in the link. However, my lookup-column allows multiple selections. Therefore the field is populated with a list of the values associated with the selections of the lookup-column, separated by commas, which is fine.

For the sake of overview, I would like to add the title of the row for each value of the list.

Now, the auto-populated field looks like this:

“Value 1, Value 2, Value 3”

I would like it to look like this:

“Value 1 (row title), Value 2 (row title), Value 3 (row title)”.

It is no problem making a formula which results in one or the other, but I am not sure how I can combine the two to achieve what I am hoping.

Any input is greatly appreciated. Thanks!

[Quentin_Morel]

Hi @Anders_Berg_Christiansen1 and welcome to our amazing community !

Please find this proposal using ForEach() and Concatenate()

Or the Format() function which is nicer

Please let me know what you think

Quentin

[Anders_Berg_Christiansen1]

Hi @Quentin_Morel,

Beautiful! Thanks a lot

I used the Format( ) and that did the trick.

I will definetely be using those functions again. Very useful. Thank you for taking the time to help.

Best regards,
Anders

[Quentin_Morel]

@Anders_Berg_Christiansen1

I used the Format( ) and that did the trick.

Great News ! Happy to help. Please let me know if you have any additional questions !

Quentin