关于产品的SKU自动生成

轮回猫

求教大神，有没有一种方法或者一种函数，能够自动生成SKU
例如，服饰的颜色红、橙、黄、绿、青、蓝、紫，尺码S\M\L\XL\2XL\3XL着一些条件都是固定的，有没有办法我输入一个服饰的名称：网红雾纱T恤,后面就能自动生成全条码的SKU，网红雾纱T恤红色S、网红雾纱T恤红色M、网红雾纱T恤红色L。。。。。等

wangrunming

麻烦点
=CONCATENATE(I7&INDEX({"红","橙","黄","绿","青","蓝","紫"},MATCH(1=1,ISNUMBER(FIND({"红","橙","黄","绿","青","蓝","紫"},I7)),0))&"色"&"S","、"&I7&INDEX({"红","橙","黄","绿","青","蓝","紫"},MATCH(1=1,ISNUMBER(FIND({"红","橙","黄","绿","青","蓝","紫"},I7)),0))&"色"&"M","、"&I7&INDEX({"红","橙","黄","绿","青","蓝","紫"},MATCH(1=1,ISNUMBER(FIND({"红","橙","黄","绿","青","蓝","紫"},I7)),0))&"色"&"L","、"&I7&INDEX({"红","橙","黄","绿","青","蓝","紫"},MATCH(1=1,ISNUMBER(FIND({"红","橙","黄","绿","青","蓝","紫"},I7)),0))&"色"&"XL","、"&I7&INDEX({"红","橙","黄","绿","青","蓝","紫"},MATCH(1=1,ISNUMBER(FIND({"红","橙","黄","绿","青","蓝","紫"},I7)),0))&"色"&"2XL","、"&I7&INDEX({"红","橙","黄","绿","青","蓝","紫"},MATCH(1=1,ISNUMBER(FIND({"红","橙","黄","绿","青","蓝","紫"},I7)),0))&"色"&"3XL")

我走我流

右拉，42列
=INDEX($A1&{"红","橙","黄","绿","青","蓝","紫"}&"色"&{"S";"M";"L";"XL";"2XL";"3XL"},MOD(COLUMN(A1)-1,6)+1,INT((COLUMN(A1)-1)/7)+1)

wangrunming

=TEXTJOIN("、",,A1&INDEX({"红","橙","黄","绿","青","蓝","紫"},MATCH(1=1,ISNUMBER(FIND({"红","橙","黄","绿","青","蓝","紫"},A1)),0))&"色"&{"S","M","L","XL","2XL","3XL"})在一个单元格内显示

轮回猫

我走我流 发表于 2020-4-4 12:47
右拉，42列
=INDEX($A1&{"红","橙","黄","绿","青","蓝","紫"}&"色"&{"S";"M";"L";"XL";"2XL";"3XL"},MOD( ...

谢谢大神，我试一下

轮回猫

wangrunming 发表于 2020-4-4 12:23
麻烦点
=CONCATENATE(I7&INDEX({"红","橙","黄","绿","青","蓝","紫"},MATCH(1=1,ISNUMBER(FIND({"红","橙 ...

谢谢大神，我试一下

轮回猫

wangrunming 发表于 2020-4-4 13:05
=TEXTJOIN("、",,A1&INDEX({"红","橙","黄","绿","青","蓝","紫"},MATCH(1=1,ISNUMBER(FIND({"红","橙","黄 ...

谢谢大神，我试一下

轮回猫

我走我流 发表于 2020-4-4 12:47
右拉，42列
=INDEX($A1&{"红","橙","黄","绿","青","蓝","紫"}&"色"&{"S";"M";"L";"XL";"2XL";"3XL"},MOD( ...

大神，请问怎么修改能够下拉行实现呢？是把COLUMN改成ROW对吗？