excel中如何实现多条件判断并返回多个值?
对于单个的HazardCodes,我会用vlookup返回一个值。但是对于f,c这样的组合的条件,我需要同时返回对应的两个值?...
对于单个的Hazard Codes,我会用vlookup返回一个值。但是对于f,c这样的组合的条件,我需要同时返回对应的两个值?
展开
展开全部
你试试改成这样
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))
下拉。
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))
下拉。
本回答被网友采纳
已赞过
已踩过<
评论
收起
你对这个回答的评价是?
展开全部
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,),)
=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,),)
本回答被提问者采纳
已赞过
已踩过<
评论
收起
你对这个回答的评价是?
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询