Lookup, return data and add reference to row title

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:

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!

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


Hi @Quentin_Morel,

Beautiful! Thanks a lot :slight_smile:

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,

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


This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.