Update Item Description Based On Accessories Ordered With It

[Electr0105]

Hey everyone,

Looking for some advice on a business order hypothetical. As per the attached image, a person orders some mobile phones and some N number of accessories. I'm looking to update the phones description based on quantity and what accessories have been orders for each order ID.

Eacher Order ID and Phone S/N are unique, and only phones have a S/N. The number of accessories won't exceed the number of phones.

Currently, I have working formulas for 0 or 1 type of accessory, but no clue how to proceed if there's 2 or more. Any help is greatly appreciated.

 

[SanjayGMusafir]

@Electr0105 Welcome to the forum

It's always a challenge working on a hypothetical data.

But based on information that can be seen in the screenshot, Check this and revert -

Book2
	A	B	C	D	E	F
1			Option 1			Option 2
2	Order ID	Desdcription	New Description		Order ID	New Description
3	A 001	M1	M1 + Cover + Plastic		A 001	M1 + Cover + Plastic
4	A 001	Cover			A 002	M2 + Cover
5	A 001	Plastic
6	A 002	M2	M2 + Cover
7	A 002	Cover
Sheet1

Cell Formulas
Range	Formula
E3:E4	E3	=UNIQUE(A3:A7)
F3:F4	F3	=TEXTJOIN(" + ",TRUE,FILTER(B3:B7,A3:A7=E3))
C3:C7	C3	=IF(A3=A2,"",TEXTJOIN(" + ",TRUE,FILTER(B3:B7,A3:A7=A3)))
Dynamic array formulas.

The only challenge is there is no parameter to correlate when to add Plastic or when to add glass. That is the challenge with hypothetical data. You need to find a way to help excel identify that...