Adding multiple cells of text into one cell based on ID number

**blockbyblock** · 07-11-2017, 05:29 AM

I'm having difficulty with combining a number of text cells all relating to one ID number into one cell which states all of the "Actions" in this case. I have tried using the VLookup function but it returns N/A because of finding text from a number. I have attached an example sheet to show my problem.
Anyone have any ideas?Example.xlsx

**AliGW** · 07-11-2017, 05:32 AM

What EXACTLY would the expected output be in your sample file?

**blockbyblock** · 07-11-2017, 05:39 AM

Taking ID 1 for example, it would be combining the actions of 1.1,1.2,1.3 maybe separated by // or similar. I am not able to change the table setup, however ugly it may be unfortunately.

**AliGW** · 07-11-2017, 05:42 AM

Please answer my question:

What EXACTLY would the expected output be in your sample file?

**blockbyblock** · 07-11-2017, 05:44 AM

If input ID is "1", Output would be "Do this//Do that//Do everything"

**AliGW** · 07-11-2017, 05:46 AM

What EXACTLY will be the output in your sample file?

Excel 2016 (Windows) 32 bit

	F	G
5	Input ID	Output Actions
6	5	Combined text of all corresponding actions

Sheet: Feuil1

**blockbyblock** · 07-11-2017, 05:49 AM

"Do this//Do that"

Sorry am I not being clear?

**AliGW** · 07-11-2017, 05:50 AM

You are now, thanks. You must learn to answer questions precisely, then you will get help quicker.

**JohnTopley** · 07-11-2017, 08:19 AM

Please Login or Register  to view this content.

2 named ranges called "ID" and "Actions" for columns B and D of your table

Refers to: =OFFSET(Feuil1!$B$4,,,COUNT(Feuil1!$B$4:$B$100),1)

and

=OFFSET(Feuil1!$D$4,,,COUNT(Feuil1!$D$4:$B$100),1)

in G6: =get_Actions(F6)