excel怎么记录数据
发布网友
发布时间：2022-04-23 06:18
共1个回答
热心网友
时间：2023-08-30 03:59
复制下列公式，具体见图片：
=VLOOKUP(--LEFT(A1,FIND(",",A1)-1),$E$1:$F$10,2,0)&","&VLOOKUP(--MID(A1,FIND(",",A1)+1,FIND("#",SUBSTITUTE(A1,",","#",2))-FIND(",",A1)-1),$E$1:$F$10,2,0)&","&VLOOKUP(--MID(A1,FIND("#",SUBSTITUTE(A1,",","#",2))+1,FIND("#",SUBSTITUTE(A1,",","#",3))-FIND("#",SUBSTITUTE(A1,",","#",2))-1),$E$1:$F$10,2,0)&","&VLOOKUP(--MID(A1,FIND("#",SUBSTITUTE(A1,",","#",3))+1,10),$E$1:$F$10,2,0)
如果数值和组数变化的话只要更改右边的辅助列就可以了。具体辅助列怎么做，用什么公式要看你具体有多少，分几组。
