第1个回答 2015-07-29
你试试改成这样
b16=if(iserror(find(",",a16)),vlookup(a16,$a$2:$c$14,2,false),vlookup(left(a16,find(",",a16)-1),$a$2:$c$14,2,false)&","vlookup(mid(a16,find(",",a16)+1,5),$a$2:$c$14,2,false))
c16=if(iserror(find(",",a16)),vlookup(a16,$a$2:$c$14,3,false),vlookup(left(a16,find(",",a16)-1),$a$2:$c$14,3,false)&","vlookup(mid(a16,find(",",a16)+1,5),$a$2:$c$14,3,false))
下拉。本回答被网友采纳
第2个回答 推荐于2016-07-08
C16公式:
=VLOOKUP(LEFT(A16,FIND(",",A16&",")-1),A$2:C$13,3,)&IF(COUNTIF(A16,"*,*"),","&VLOOKUP(MID(A16,FIND(",",A16)+1,9),A$2:C$13,3,),)本回答被提问者采纳