asked on Draw several entries from another worksheet and enter them in one cell separated by manual line breaks
Dear Experts:
I wonder whether the following is feasible with a formula:
I would like to draw the WashingCode Descriptions for different items and enter them in the Column that has got the Description_Formula Header.
The code descriptions are to be separated by a manual line break.
Is this feasible with a formula or do I need VBA programming?
I have attached a similar sample table for your convenience.
Help is very much appreciated. Thank you very much in advance.
Regards, Andreas
ItemCode WashingCode_1 WashingCode_2 WashingCode_3 Description_Formula
Z1 101 102 103 Sterile
Manual Washing
No Rubbing
Z2 102 104 105 Manual Washing
Dry Cleaning
Mild Detergents
On the Second Worksheet (named WashingCodes) the WashingCodes are listed in a table along with their description
WashingCodes Description
101 Sterile
102 Manual Washing
103 No Rubbing
104 Dry Cleaning
105 Mild Detergents
Draw_mulitple_entries_merge_in_one_.xlsx
I wonder whether the following is feasible with a formula:
I would like to draw the WashingCode Descriptions for different items and enter them in the Column that has got the Description_Formula Header.
The code descriptions are to be separated by a manual line break.
Is this feasible with a formula or do I need VBA programming?
I have attached a similar sample table for your convenience.
Help is very much appreciated. Thank you very much in advance.
Regards, Andreas
ItemCode WashingCode_1 WashingCode_2 WashingCode_3 Description_Formula
Z1 101 102 103 Sterile
Manual Washing
No Rubbing
Z2 102 104 105 Manual Washing
Dry Cleaning
Mild Detergents
On the Second Worksheet (named WashingCodes) the WashingCodes are listed in a table along with their description
WashingCodes Description
101 Sterile
102 Manual Washing
103 No Rubbing
104 Dry Cleaning
105 Mild Detergents
Draw_mulitple_entries_merge_in_one_.xlsx
Microsoft OfficeVBAMicrosoft Excel
Last Comment
Rob Henson
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Hi Koen,
wow this is awesome, exactly as I wanted it
Hi Rob,
will test it this afternoon and then let you know.
Thank you to both of you ...
wow this is awesome, exactly as I wanted it
Hi Rob,
will test it this afternoon and then let you know.
Thank you to both of you ...
Koen's file has the exact same formula as I posted in my first comment. The second version just allows for error trapping.
ASKER
I suggest splitting the points. Koen, thank you very much for already entering the formula in my sample file, very convenient.
I realy appreciate your great job, Koen and Rob
Have a nice weekend, Andreas
I realy appreciate your great job, Koen and Rob
Have a nice weekend, Andreas
Yeah Rob was first but i was making the excel..comments are only minutes apart...
Glad to help.
=VLOOKUP(B2,Tabelle1[#All]
Format the cell with Wrap Text enabled.
CHAR(10) is the Ascii code for a Carriage Return.