这个公式
=IF(COUNTIF(G4,"*基站*")=1,IF(FIND("管道",VLOOKUP(G4,G:I,3,FALSE))<>0,SUBSTITUTE(VLOOKUP(...
=IF(COUNTIF(G4,"*基站*")=1,IF(FIND("管道",VLOOKUP(G4,G:I,3,FALSE))<>0,SUBSTITUTE(VLOOKUP(G4,G:I,3,0),MID(VLOOKUP(G4,G:I,3,0),FIND("管",VLOOKUP(G4,G:I,3,0)),FIND("井",VLOOKUP(G4,G:I,3,0))+1-FIND("管",VLOOKUP(G4,G:I,3,0))),"管道"),SUBSTITUTE(VLOOKUP(G4,G:I,3,0),MID(VLOOKUP(G4,G:I,3,0),FIND("0",VLOOKUP(G4,G:I,3,0)),FIND("井",VLOOKUP(G4,G:I,3,0))+1-FIND("0",VLOOKUP(G4,G:I,3,0))),"管道")),IF(COUNTIF(G4,"*管道*")=1,SUBSTITUTE(G4,MID(G4,FIND("管",G4),FIND("井",G4)+1-FIND("管",G4)),"管道"),SUBSTITUTE(G4,MID(G4,FIND("0",G4),FIND("井",G4)+1-FIND("0",G4)),"管道")))
展开
1个回答
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
